The SnowPro Advanced: Administrator Certification validates advanced knowledge of Snowflake account operations, security design, and cost optimization. It comprehensively tests features administrators use every day: network policies, RBAC, MFA/SSO, Resource Monitor, and ACCOUNT_USAGE views. This article walks through the exam overview, domains, and key study points for each topic.
| Item | Details |
|---|---|
| Exam code | ADA-C02 |
| Questions | 65 (multiple choice, multiple select, and interactive) |
| Duration | 115 minutes |
| Passing score | 750 / 1000 |
| Exam fee | $375 USD |
| Prerequisite | Active SnowPro Core certification |
| Delivery | Pearson VUE (test center or online) |
| Validity | 2 years |
| Recommended experience | 2+ years of hands-on Snowflake administration |
| Language | English only |
These are the six domains listed on the official exam page and in the Study Guide (ADA-C02, last updated December 1, 2025).
| Domain | Weight | Key Topics |
|---|---|---|
| 1.0 Snowflake Security, RBAC, and User Administration | 31% | Administrative roles (ORGADMIN/ACCOUNTADMIN), DAC/RBAC/UBAC, custom roles, database roles and future grants, SSO/SAML, OAuth, MFA and key-pair authentication, network rules/policies and private connectivity, SCIM |
| 2.0 Account Management & Data Governance | 18% | Organization and account management, Tri-Secret Secure and encryption key rotation, masking policies, external tokenization and row access policies, tagging and data classification, ACCESS_HISTORY, Trust Center and Horizon Catalog |
| 3.0 Data and Object Management | 15% | Warehouse configuration (auto-suspend, multi-cluster), tables and views (external and Iceberg tables), cloning, storage integrations, tasks, Snowsight dashboards |
| 4.0 Performance Monitoring & Tuning | 20% | Query Profile, caching, spilling and pruning; search optimization, query acceleration and materialized views; DML locking; resource monitors; event tables (logging and tracing); cost management with ACCOUNT_USAGE and ORGANIZATION_USAGE |
| 5.0 Data Sharing and Snowflake Marketplace | 7% | Creating and managing shares, secure views and secure UDFs, reader accounts, cross-region and cross-cloud sharing, Data Clean Rooms, Marketplace listings |
| 6.0 Disaster Recovery, Backup & Data Replication | 9% | Database and account replication, replication groups and failover groups, failover/failback, client redirect, Time Travel and Fail-safe |
Snowflake's access control combines RBAC (Role-Based Access Control) with DAC (Discretionary Access Control). The most important exam topics are role hierarchy design and how GRANT statements behave.
| Default Role | Key Privileges | Manages |
|---|---|---|
| ACCOUNTADMIN | All privileges (SYSADMIN + SECURITYADMIN) | Entire account; creates Resource Monitors |
| SECURITYADMIN | MANAGE GRANTS privilege | Roles, users, and privilege management |
| SYSADMIN | CREATE DATABASE/WAREHOUSE | Databases, schemas, and warehouses |
| USERADMIN | CREATE USER/ROLE | Creating users and roles |
| PUBLIC | Basic access privileges | Automatically granted to every user |
Best practice is to place custom roles under SYSADMIN. If a custom role is not in SYSADMIN's hierarchy, system administrators (SYSADMIN) cannot manage the objects it owns. Only roles granted the MANAGE GRANTS privilege (by default, only SECURITYADMIN) can view those objects and modify their access grants.
| Setting | Description |
|---|---|
| CREDIT_QUOTA | Maximum credit consumption within the monitoring period |
| FREQUENCY | DAILY / WEEKLY / MONTHLY / YEARLY / NEVER |
| START_TIMESTAMP | When monitoring begins |
| TRIGGERS (NOTIFY) | Notify account administrators when the threshold is reached |
| TRIGGERS (SUSPEND) | Suspend the warehouse after running queries finish when the threshold is reached |
| TRIGGERS (SUSPEND_IMMEDIATELY) | Cancel running queries and suspend the warehouse immediately when the threshold is reached |
The snowflake.account_usage schema contains views for analyzing account usage.
ACCOUNT_USAGE views have a data latency of up to 45 minutes to 3 hours (and keep 1 year of history). When you need near-real-time information, use INFORMATION_SCHEMA instead (note that its retention ranges from 7 days to 6 months, depending on the view).
| Cost Component | Billing Unit | Optimization |
|---|---|---|
| Compute | Credits (warehouse size x runtime) | Shorten auto-suspend; right-size warehouses |
| Storage | TB/month (On-Demand or Capacity contract) | Tune Time Travel retention; remove unused data |
| Data transfer | Cross-region / cross-cloud transfer volume | Process within the same region; optimize replication |
| Serverless | Snowpipe, tasks, materialized views, etc. | Tune Snowpipe ingestion frequency |
| Cloud Services | Billed only above the 10% threshold | Avoid excessive SHOW/DESCRIBE calls |
The Administrator exam rewards real operations experience. Focus on these hands-on exercises:
SnowPro Advanced: Administrator
Question 1
In Snowflake, you want to allow access only from a specific IP range while excluding some IPs within that range. How should the network policy be configured?
Correct answer: A
Define the allowed range with ALLOWED_IP_LIST and specify the IPs to exclude with BLOCKED_IP_LIST. BLOCKED_IP_LIST functions as a subset of ALLOWED_IP_LIST. When only ALLOWED_IP_LIST is set, every IP not in the list is blocked.
Are SQL operation questions on the SnowPro Advanced Administrator exam?
Yes, administrative SQL commands are tested. Specifically, role and privilege management with GRANT/REVOKE, CREATE NETWORK POLICY, ALTER ACCOUNT, CREATE RESOURCE MONITOR, SHOW PARAMETERS, and ALTER USER SET/UNSET are all in scope. SELECT-based analytical queries are rare; most scenarios involve querying ACCOUNT_USAGE/INFORMATION_SCHEMA views to inspect resource consumption or login history.
How does the security domain differ between the Administrator and Core exams?
Core focuses on role hierarchies and basic GRANT behavior, while Administrator goes deeper into real operations: network policy design (CIDR ranges and policy precedence), SSO/SAML setup procedures, SCIM provisioning, column-level and row-level security, Tri-Secret Secure, and key rotation policies.
At what granularity can Resource Monitors be set, and how are they tested?
Resource Monitors can be configured at the account level or for individual warehouses. You combine a credit quota, a frequency (DAILY/WEEKLY/MONTHLY/YEARLY/NEVER), and threshold actions (NOTIFY/SUSPEND/SUSPEND_IMMEDIATELY). Typical exam scenarios are like "suspend the warehouse if monthly usage exceeds 100 credits" — you pick the correct configuration. The fact that only the ACCOUNTADMIN role can create Resource Monitors comes up frequently.
Practice with certification-focused question sets
Try free questionsNicheeLab Editorial Team
NicheeLab editorial team focused on data engineering and cloud certification learning. Content is structured around practical study needs and official exam domains.
Snowflake Certifications: All 11 Exams Explained (2026)
Every SnowPro certification on Snowflake's official list — C...
Snowflake Exam Difficulty Ranking: All 11 Certs Compared (2026)
All 11 SnowPro exams compared by difficulty in a ranking and...
Snowflake Study Guide: Fastest Pass Route by Exam (2026)
How to pass SnowPro certifications efficiently — official ma...
SnowPro Core (COF-C03): Complete Exam Guide (2026)
Pass the SnowPro Core exam — five domains, scope, sample que...
SnowPro Associate Platform (SOL-C01): Current Status & What to Take Next (2026)
As of October 2026, SnowPro Associate: Platform (SOL-C01) is...