ADA-C01 practice examsIn development
SnowPro Advanced: Administrator
Administering Snowflake: organisation and account configuration, a role hierarchy separating functional from access roles, authentication and governance with tags and masking, warehouse sizing and scaling policies, resource monitors as the only real cost ceiling, Time Travel against Fail-safe, and account monitoring.
What you get
Papers are cut from the bank and weighted like the real exam, and no question appears in two of them. Every wrong answer comes back on later days until you have it right.
What the exam covers
| Account management, security and access | Not published |
| Performance, cost management, data protection and monitoring | Not published |
Two sample questions
1. What does the WAREHOUSE_METERING_HISTORY view show?
- Queries submitted by each user
- Storage used by each database
- Grants made to each role
- Credits used by each warehouse — correct
Why: Chargeback reporting is usually built on it.
2. What is a practical reason to create custom functional roles?
- To speed up loads
- To shrink storage
- To match job duties — correct
- To widen Time Travel
Why: Custom functional roles align privileges to real job responsibilities.
The real ADA-C01 exam
| Length | 115 minutes |
|---|---|
| Questions | 65 |
| Pass mark | 750 on a scale of 0 to 1000 |
| Price | $375 USD |
| Recommended before you sit it | SnowPro Core certification is required, along with two or more years of Snowflake administration experience. |
| Valid for | 2 years |
Exam facts as published by Snowflake; always check the vendor’s page before you book.
Study ADA-C01 with Chiron
Chiron is invitation-only while we are in beta, and nothing is for sale yet: invited accounts use every paper, drill and course note for free.