Prepare with Snowflake : ADA-C01 exam braindumps as your best preparation materials

If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?

• A. No, because the optimizer might decide against it.
• B. No, because joins are not supported by materialized views.
• C. No, because the materialized view may not be up-to-date.
• D. Yes, because materialized views are always faster.

A Snowflake account is configured with SCIM provisioning for user accounts and has bi-directional synchronization for user identities. An Administrator with access to SECURITYADMIN uses the Snowflake UI to create a user by issuing the following commands:
use role USERADMIN;
create or replace role DEVELOPER_ROLE;
create user PTORRES PASSWORD = 'hello world!' MUST_CHANGE_PASSWORD = FALSE default_role = DEVELOPER_ROLE; The new user named PTORRES successfully logs in, but sees a default role of PUBLIC in the web UI. When attempted, the following command fails:
use DEVELOPER_ROLE;
Why does this command fail?

• A. The new role will only take effect once the identity provider has synchronized by way of SCIM with the Snowflake account.
• B. USERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER.
• C. The new role can only take effect after USERADMIN has logged out.
• D. The DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able to use the role.

A data provider wants to share data from multiple databases with a data consumer account.
How can this be accomplished?

• A. The data provider needs to create a secure view and must grant the REFERENCE_USAGE privilege on the database where the secure view is created.
• B. The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege on each database referenced by the secure view.
• C. The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege to a database role to include objects from multiple databases in a share
• D. The data provider needs to create a secure view and grant the USAGE privilege on each database referenced by the secure view.

An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it into different production tables.
How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?

• A. Create it as a temporary table with a retention time of 0 days.
• B. Create it as an external table, which will not incur Time Travel costs.
• C. Create it as a permanent table with a retention time of 0 days.
• D. Create it as a transient table with a retention time of 0 days.

In general, the monthly billing for database replication is proportional to which variables? (Select TWO).

• A. The frequency of changes to the primary database as a result of data loading or DML operations
• B. The frequency of the secondary database refreshes from the primary database
• C. The amount of table data in the primary database that changes as a result of data loading or DML operations
• D. The number and size of warehouses defined in the primary account
• E. The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts