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 Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous
loT data. Time Travel is being used as a component of the company's data quality process in which the ingestion pipeline should revert to a known quality data state if any
anomalies are detected in the latest load. Data from the past 30 days may have to be retrieved because of latencies in the data acquisition process.
According to best practices, how should these requirements be met? (Select TWO).
What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?
A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business Critical edition. The minimum number of clusters is set to 2 and the
maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the
Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.
Which solutions will address the issues happening once a month? (Select TWO).