Snowflake Related Exams
ADA-C01 Exam
The exam covers five domains:
Security, RBAC, and User Administration (30–35%)
Account Management and Governance (20–25%)
Database Objects & Virtual Warehouses (20–25%)
Performance Monitoring & Optimization (15–20%)
Data Sharing, Replication & Disaster Recovery (10–15%)
ADA-C01 focuses on Snowflake administration tasks like security, governance, and performance tuning, whereas ADA-R01 validates advanced architectural design skills for building scalable, secure, and optimized Snowflake solutions.
Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Select TWO).
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?
MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is
'8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.
Which queries will allow the user to view the historical data that was in the table before this query was executed? (Select THREE).