SnowPro Advanced: Administrator
Snowflake · SnowPro Certification Prep
Theory
The SnowPro Advanced: Administrator certification, currently exam ADA-C02, is for people who run Snowflake accounts day to day. It covers security and user administration (users, roles, RBAC design, authentication, network policies), account management and data governance (parameters, masking and row access policies, tagging), performance monitoring and tuning (warehouses, resource monitors, query history), data sharing and the Marketplace, and disaster recovery through replication and failover.
Questions test operational judgement, for example how to stop runaway spend on a warehouse without cancelling critical queries, or how to grant a team access with least privilege. Exam versions change, so check the current study guide for domains and weights.
Why we use it
It validates the skills that keep a Snowflake account secure, compliant and cost-controlled, which matters to any company running Snowflake in production.
When to use it
Take it after Core when you manage users, roles, warehouses and costs. If your role is designing the platform rather than operating it, compare it with the Architect exam.
Exam Format & Domains
The current version is ADA-C02. Like the other Advanced exams it requires an active SnowPro Core certification and is built from scenario questions. Snowflake's official ADA-C02 study guide lists the exact domains, weights, question count, time and fee; use it rather than older blog posts.
Highest-Value Topics to Study
User provisioning via SCIM/SSO/SAML/OAuth, network policies and private connectivity, MFA enforcement, RBAC role-hierarchy design, resource monitors and cost control, replication and failover groups, and compliance standards like HIPAA, SOC 2, and PCI DSS.
How to Prepare
Focus on operational judgment questions — how to provision users safely at scale, how to set up alerting before a cost overrun happens — rather than memorizing every SQL DDL option, since this exam is closer to running the platform than writing queries against it.
How it works
- Hold an active SnowPro Core certification
- Read the current Administrator study guide
- Practise role design, resource monitors and network policies
- Can you solve access and cost incidents step by step? Yes: Practise scenario questions. No: Rehearse with ACCOUNT_USAGE queries.
- Book the exam
Example
-- Self-check: can you design a resource monitor + alerting
-- setup that catches runaway spend before it happens?Key points
- Requires an active SnowPro Core certification
- Current exam version: ADA-C02
- Focused on account operations, compliance and monitoring
- Know resource monitors, budgets and ACCOUNT_USAGE views well
- Tests operational judgement more than SQL syntax recall