Snowflake ADA-C02 Exam Syllabus Topics:

Snowflake SnowPro Advanced Administrator ADA-C02 Sample Questions:

Question #1
What are benefits of using Snowflake organizations? (Choose two.)

A. Administrators have the ability to create accounts in any available cloud provider or region.
B. User administration is simplified across all accounts within the organization.
C. Administrators can change Snowflake account editions on-demand based on need.
D. Administrators can simplify data movement across all accounts within the organization.
E. Administrators can monitor and understand usage across all accounts in the organization.

Question #2
Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

A. Manage system grants
B. Create new roles
C. Reset a Snowflake user's password
D. Create new users

Question #3
Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Choose two.)

A. SHOW USERS;
B. GRANT ROLE ORGADMIN TO USER <username>;
C. SHOW REGIONS;
D. SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('ACCOUNT_LOCATOR','ENABLE_ACCOUNT_DATABASE_REPLICATION','true');
E. SHOW ORGANIZATION ACCOUNTS;

Question #4
What are characteristics of data replication in Snowflake? (Choose three.)

A. Users can have unlimited primary databases and they can be replicated to an unlimited number of accounts if all accounts are within the same organization.
B. To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.
C. The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.
D. Users must be granted REPLICATIONADMIN privileges in order to enable replication.
E. Replication can only occur within the same cloud provider.
F. Databases created from shares can be replicated.

Question #5
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:
At 80% usage notify the account Administrators.
At 100% usage suspend the warehouse and notify the account Administrators.
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
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;
D. 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;

Solutions: