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.
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?
The ACCOUNTADMIN of Account 123 works with Snowflake Support to set up a Data Exchange. After the exchange is populated with listings from other Snowflake accounts,
what roles in Account 123 are allowed to request and get data?
Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Select TWO).