SNOWPRO-ADVANCED-ADMINISTRATOR: SnowPro Advanced: Administrator

About the SnowPro Advanced: Administrator Exam

Master the Snowflake SnowPro Advanced: Administrator certification (ADA-C02) — security, RBAC and user administration, account management and data governance, data and object management, performance monitoring and tuning, secure data sharing and the Marketplace, and disaster recovery, backup and replication.

The complete practice exam for the Snowflake SnowPro Advanced: Administrator certification (ADA-C02). This advanced, administrator-level exam goes deeper than SnowPro Core — it tests how you operate, secure, govern, and tune an enterprise Snowflake account. Covers Snowflake security, RBAC and user administration (the ACCOUNTADMIN / SECURITYADMIN / USERADMIN / SYSADMIN role hierarchy, custom roles and inheritance, future grants, managed access schemas, RBAC vs DAC, ownership transfer, database roles vs account roles, secondary roles, users and service users, authentication / password / session policies, MFA, network policies and rules, SAML SSO / SCIM / OAuth / key-pair auth, and the privilege model), account management and data governance (account and session parameters, ORGADMIN and organizations, resource monitors and budgets, dynamic masking and row access and aggregation / projection policies, object tagging and tag-based masking, secure views, ACCESS_HISTORY and ACCOUNT_USAGE), data and object management (database / schema / table types, zero-copy cloning, stages and COPY INTO and Snowpipe, streams and tasks, micro-partitions), performance monitoring and tuning (warehouse sizing and multi-cluster scaling, caching, the Query Acceleration and Search Optimization services, clustering keys, materialized views, Query Profile, and cost optimization), secure data sharing and the Marketplace (direct shares, reader accounts, listings, cross-cloud auto-fulfillment), and disaster recovery, backup and replication (Time Travel and Fail-safe, replication and failover groups, Client Redirect, business continuity) — every question a real-world administration scenario with full explanations.

Who Should Take This Exam?

The SnowPro Advanced: Administrator certification is designed for Snowflake administrators, platform engineers, DBAs, and security/governance leads who manage and operate enterprise-scale Snowflake accounts. It validates advanced operational judgment across RBAC and security, account governance, performance and cost tuning, sharing, and business continuity.

Prerequisites: SnowPro Core Certified

Typical study time: 6-10 weeks of focused study (plus hands-on Snowflake administration experience)

Exam Quick Facts

Exam Domains & Weights

The SnowPro Advanced: Administrator exam covers 6 domains. Focus your study time based on the weights below — higher-weighted domains have more exam questions.

💡 Study tip: Security, RBAC and User Administration (31%) is the heaviest domain — know the ACCOUNTADMIN / SECURITYADMIN / USERADMIN / SYSADMIN hierarchy cold, plus future grants, managed access schemas, secondary roles, and the difference between authentication policies, network policies, and key-pair / SSO / SCIM. Performance Monitoring and Tuning (20%) is decision-making: warehouse sizing and multi-cluster scaling policy (Standard vs Economy), the three caches, and clustering vs Search Optimization vs Query Acceleration. Account Management and Governance (18%) rewards resource monitors, masking, row access and aggregation policies. Don’t skip Disaster Recovery (9%) — be sure you can pick a replication group vs a failover group and reason about Time Travel vs Fail-safe.

Practice Exam — 250 Questions

Prepare for the SnowPro Advanced: Administrator with our 250-question practice exam covering all 6 exam domains. Every question is a real-world administration scenario with detailed explanations and maps to official exam objectives.

What you get:

• ✅ Exam simulation mode with timer
• ✅ Spaced repetition for weak areas
• ✅ Detailed explanations for every question
• ✅ Progress tracking across domains
• ✅ 20 free questions — no account needed

Snowflake Certification Path

Start with the SnowPro Core Certification (the broad, foundational credential and a prerequisite for the Advanced track), then specialise with the SnowPro Advanced certifications — Architect, Data Engineer, Administrator, Data Analyst, and Data Scientist — which go deeper into role-specific design and operations.

Study Tips

1. Lead with RBAC and security — the heaviest domain rewards knowing the role hierarchy, future grants, managed access schemas, and the policy stack (authentication, network, password, session) cold
2. Use our practice exam — try the 20 free questions first to gauge your readiness for the advanced level
3. Get hands-on in a trial account — practise resource monitors, masking and row access policies, multi-cluster scaling, and replication / failover groups in a real Snowflake account
4. Think in trade-offs — the admin exam is about choosing (replication vs failover group; clustering vs Search Optimization vs QAS; Standard vs Economy scaling); read every explanation for the why
5. Check the official page — official exam details always have the latest objectives