Free Snowflake ADA-C01 Exam Dumps Questions & Answers

What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?

• A.ACCOUNTADMIN and SECURITYADMIN
• B.Any role with GRANT USAGE on SECURITY INTEGRATION
• C.ACCOUNTADMIN only
• D.ACCOUNTADMIN and SYSADMIN

An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that will perform the following tasks:
1. At 80% usage notify the account Administrators.
2. At 100% usage suspend the warehouse and notify the account Administrators.
3. At 120% stop all running executions, suspend the warehouse, and notify the account Administrators.
Which SQL command will meet these requirements?

• A.create or replace resource monitor RM1 with credit_quota=3000
  start_timestamp = '2022-01-01 00:00 CET'
  triggers on 80 percent do notify
  on 100 percent do notify and suspend
  on 120 percent do notify and suspend_immediate;
  alter warehouse WH1 set resource monitor = RM1;
• B.create or replace resource monitor RM1 with credit_quota=3000
  start_timestamp = '2022-01-01 00:00 CET'
  triggers on 80 percent do notify
  on 100 percent do suspend
  on 120 percent do suspend_immediate;
  alter warehouse WH1 set resource_monitor = RM1;
• C.create or replace resource monitor RM1 with credit_quota=3000
  frequency = yearly
  triggers on 80 percent do notify
  on 100 percent do suspend
  on 120 percent do suspend_immediate;
  alter warehouse WH1 set resource_monitor = RM1;
• D.create or replace resource monitor RM1 with credit_quota=3000
  frequency = yearly
  start_timestamp = '2022-01-01 00:00 CET'
  triggers on 80 percent do notify
  on 100 percent do suspend
  on 120 percent do suspend_immediate;
  alter warehouse WH1 set resource monitor = RM1;

What is a characteristic of Snowflake's transaction locking and concurrency modeling?

• A.Transaction locking in Snowflake is enforced exclusively at the row and table levels.
• B.Queries executed within a given transaction see that transaction's uncommitted changes.
• C.If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.
• D.A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.

A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTs rather than bulk loading of large extracts. That single warehouse has been configured as a single cluster, 2XL because there are many parallel INSERTs that are scheduled during nightly loads.
How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?

• A.The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.
• B.There should be another 2XL warehouse deployed to handle a portion of the load queries.
• C.The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.
• D.The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.

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 grant the REFERENCE_USAGE privilege on each database referenced by the secure view.
• B.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.
• C.The data provider needs to create a secure view and grant the USAGE privilege on each database referenced by the secure view.
• D.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