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.
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 Snowflake Administrator is investigating why a query is not re-using the persisted result cache.
The Administrator found the two relevant queries from the SNOWFLAKE. ACCOUNT_USAGE. QUERY_HISTORY view:

Why is the second query re-scanning micro-partitions instead of using the first query's persisted result cache?
What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?