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.
What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?
A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant.
An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse.
What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Select TWO).
Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Select TWO).