Snowflake · ADA-C02
SnowPro Advanced: Administrator (ADA-C02) Practice Tests
Validates advanced skills in managing Snowflake accounts including data security, governance, RBAC, performance tuning, data sharing, and disaster recovery. Designed for administrators with 2+ years of hands-on Snowflake production experience.
Exam Details
Practice Questions
600
≈ 6 practice exams
Duration
115 minutes
Passing Score
750/1000
Difficulty
ProfessionalLast Updated
Jun 2026
Topics Covered
Snowflake Security, RBAC, and User AdministrationAuthentication (SSO, MFA, OAuth, Key Pair)Network Policies and Private ConnectivityData Governance and Access ControlDatabase Object and Virtual Warehouse ManagementQuery Performance Monitoring and OptimizationData Sharing and Snowflake MarketplaceDisaster Recovery, Backup, and Data Replication
SnowPro Advanced: Administrator (ADA-C02) Practice Exam Preparation
Use this ADA-C02 practice exam to prepare for SnowPro Advanced: Administrator (ADA-C02) with realistic questions, detailed explanations, and focused study modes. The practice bank includes 600 questions for Snowflake ADA-C02, so you can review the exam steadily instead of relying on one long cram session.
As you practice, pay extra attention to recurring topics such as Snowflake Security, RBAC, and User Administration, Authentication (SSO, MFA, OAuth, Key Pair), Network Policies and Private Connectivity, Data Governance and Access Control, and Database Object and Virtual Warehouse Management. Start with short sessions to identify weak areas, then move into timed quizzes once your accuracy is consistent.
The explanations are especially useful when you want to connect exam wording to the responsibilities and scenarios described in the official certification guidance. Use the free preview first, then unlock the full question bank when you are ready to build a complete study routine.
Exam Domain Breakdown
Snowflake Security, RBAC, and Administration30%
Account Management and Data Governance25%
Exam Overview
The SnowPro® Advanced: Administrator (ADA-C02) is Snowflake's professional-level certification that validates deep expertise in administering, securing, and optimizing Snowflake Data Cloud environments. Launched on January 19, 2026 as the successor to the ADA-C01, this credential covers the full spectrum of advanced administrative responsibilities including role-based access control architecture, federated authentication, data governance policies, virtual warehouse optimization, and cross-cloud replication. It is one of five SnowPro Advanced certifications and sits above the SnowPro Core in Snowflake's certification hierarchy.
The exam tests a candidate's ability to design and enforce security boundaries using network policies, private connectivity, and SCIM-based identity management; implement column-level and row-level security through masking and access policies; tune query performance using Query Profiles and caching strategies; orchestrate data sharing via the Snowflake Marketplace and private exchanges; and build resilient disaster recovery architectures using database replication, Time Travel, and Fail-safe. The ADA-C02 revision notably replaces the former Data Transformation domain with a dedicated Disaster Recovery, Backup, and Replication domain, reflecting Snowflake's growing enterprise focus on operational resilience.
Who Should Take This Exam
The ADA-C02 is designed for experienced practitioners who manage Snowflake environments in production settings. Primary target roles include Snowflake Administrators, Snowflake Data Cloud Administrators, Cloud Infrastructure Administrators, Database Administrators (DBAs), Cloud Data Administrators, and Application Developers who handle platform governance responsibilities. The credential is most relevant for professionals who own account-level configuration, security policy enforcement, cost management, and data sharing arrangements within their organizations.
Candidates should have at least two years of hands-on Snowflake administrative experience in a production environment before attempting the exam. Those transitioning from traditional DBA roles into cloud data platforms, or cloud engineers seeking to formalize their Snowflake expertise, will find this certification a strong signal of advanced capability to employers.
Prerequisites
Snowflake requires candidates to hold an active SnowPro Core Certified credential before sitting for the ADA-C02. The SnowPro Core covers foundational Snowflake concepts including architecture, data loading, query fundamentals, and basic account management, and serves as the essential baseline for the advanced content tested here.
Beyond the formal prerequisite, Snowflake strongly recommends a minimum of two years of hands-on Snowflake administrative experience in a production environment. Candidates should be fluent in both ANSI SQL and Snowflake-extended SQL, comfortable navigating the Snowsight interface and SnowSQL CLI, and familiar with cloud networking concepts (VPC/VNet, private endpoints) across at least one major cloud provider (AWS, Azure, or GCP). Practical experience configuring identity providers for SSO, designing RBAC hierarchies, and working with resource monitors is highly advisable.
Exam Format
The ADA-C02 consists of 65 scored questions for first-time certification candidates, or 40 questions for those recertifying, both within a 115-minute time limit. Questions are primarily scenario-based and situational, requiring candidates to evaluate multiple technically valid options and select the most appropriate or cost-effective solution — not simply recall definitions. The exam is delivered online through Certmetrics and costs $375 USD per attempt.
Scoring follows a scaled system ranging from 0 to 1,000, with a passing score of 750. The certification remains valid for two years from the issue date, after which holders must recertify through Snowflake's Continuing Education program. Snowflake does not publish a breakdown of scored versus unscored (pretest) questions for this exam.
Skills Measured
- 1.Domain 1 – Snowflake Security, RBAC, and Administration (30%): Covers federated authentication and SSO configuration with identity providers, MFA enforcement, key-pair authentication and rotation, OAuth 2.0 token management, SCIM integration for user and group provisioning, network policy design, private connectivity setup (AWS PrivateLink, Azure Private Link, GCP Private Service Connect), RBAC hierarchy design, privilege management, and preventing data exfiltration. This is the highest-weighted domain on the exam.
- 2.Domain 2 – Account Management and Data Governance (25%): Covers Snowflake Organization management, multi-account strategies, Tri-Secret Secure encryption and customer-managed key (CMK) configuration, column-level security via dynamic data masking and external tokenization, row access policies, object tagging and data classification, and auditing through the Account Usage schema and INFORMATION_SCHEMA views.
- 3.Domain 3 – Performance and Cost Optimization (approx. 20%): Covers virtual warehouse sizing, multi-cluster warehouse configuration, auto-suspend and auto-resume tuning, query performance analysis using Query Profile and EXPLAIN plans, result set caching and metadata caching strategies, micro-partition pruning, clustering keys, resource monitor configuration, and credit consumption reporting.
- 4.Domain 4 – Data Sharing and Collaboration (approx. 15%): Covers secure data sharing fundamentals, one-to-one and one-to-many sharing configurations, private data exchange setup and membership management, Snowflake Marketplace listing creation and management, provider profiles, cross-region and cross-cloud data sharing, and Data Clean Rooms concepts.
- 5.Domain 5 – Disaster Recovery, Backup, and Data Replication (approx. 10%): Covers database and account replication across regions and cloud providers, replication group configuration, failover and failback procedures, disaster recovery planning, Time Travel configuration and usage for querying historical data and restoring dropped objects, and Fail-safe retention periods and limitations. This domain is new to the ADA-C02 and replaces the Data Transformation domain from the prior ADA-C01 version.
Study Tips
- Download and structure your study plan around the official ADA-C02 Exam Study Guide available on learn.snowflake.com. It lists every subdomain with linked Snowflake documentation, blog posts, and exercises — treat it as your curriculum rather than a reference to skim at the end.
- Prioritize Domain 1 (Security/RBAC at 30%) and Domain 2 (Governance at 25%) together, as they account for more than half the exam. Build a sandbox Snowflake account and hands-on configure SSO with a free Okta developer tenant, implement dynamic data masking policies on PII columns, and design a multi-role RBAC hierarchy from scratch.
- For Domain 3 performance tuning, practice reading actual Query Profiles in Snowsight. Load a large dataset, run queries with and without clustering keys, observe partition pruning statistics, and deliberately create warehouse contention to understand multi-cluster scaling behavior. The exam favors scenario questions requiring you to diagnose performance issues from Profile output.
- Study the ADA-C02 with a focus on cost-versus-functionality trade-offs, as many scenario questions present multiple technically correct options and test whether you can identify the most cost-effective approach. For example, understand when cross-region replication via replication groups is preferable to ETL-based duplication, and when a single-cluster warehouse suffices over a multi-cluster configuration.
- Use the Snowflake Account Usage schema (SNOWFLAKE.ACCOUNT_USAGE) and INFORMATION_SCHEMA views as hands-on study tools. Query LOGIN_HISTORY, QUERY_HISTORY, ACCESS_HISTORY, and DATA_TRANSFER_HISTORY to understand governance auditing — these views appear frequently in Domain 2 and Domain 3 questions.
- Since Domain 5 (Disaster Recovery) is entirely new in ADA-C02 and replacing a previously tested area, allocate dedicated study time to Snowflake's documentation on replication groups, failover/failback, and the operational differences between Time Travel (configurable, up to 90 days on Enterprise+) and Fail-safe (fixed 7 days, non-configurable, Snowflake-managed recovery only).
- Take at least two timed full-length practice exams under exam conditions before your attempt. The 65-question, 115-minute format averages under 2 minutes per question, and many scenario questions are lengthy — time management is a practical skill to develop, not just content knowledge.
Career Benefits
Earning the ADA-C02 positions administrators for senior and principal-level roles in organizations that run Snowflake at scale, including titles such as Senior Snowflake Administrator, Cloud Data Platform Engineer, Data Infrastructure Architect, and Database Reliability Engineer. Snowflake-certified administrators report salaries in the range of $120,000 to $150,000 USD annually at the mid-level, with senior professionals commanding $150,000 to $185,000 base in 2025–2026. Principal-level architects with SnowPro Advanced credentials alongside complementary cloud certifications (AWS, Azure, or GCP) can reach $210,000 to $265,000 in total compensation at larger enterprises.
Snowflake's rapid enterprise adoption — with over 10,000 enterprise customers and a significant demand-supply gap for experienced administrators — means the ADA-C02 carries strong market signal value. Compared to the entry-level SnowPro Core, the Advanced Administrator credential demonstrates the operational depth that platform engineering and data infrastructure teams require when entrusting someone with account-level security, compliance enforcement, and cross-cloud replication. It is frequently listed alongside cloud provider certifications as a preferred or required qualification in senior data platform engineering job postings.
Sample Questions
5 sample questions with answers and explanations. The full bank has 600 questions, enough for 6 full-length practice exams.
Preview — answers shown1. A data engineering team at Fabrikam Healthcare is building an automated pipeline that creates intermediate staging tables from a production PATIENTS table. The PATIENTS table has a dynamic data masking policy on the EMAIL column that returns the real email address only to the DATA_ADMIN role and returns a masked placeholder (e.g., 'xxxx@xxxx.com') to all other roles. A pipeline service account running as PIPELINE_ROLE executes a CREATE TABLE AS SELECT (CTAS) statement to copy the PATIENTS table into an intermediate staging table. What will be stored in the EMAIL column of the newly created intermediate table? (Select one!)
ANULL values in the EMAIL column, because Snowflake blocks CTAS operations from reading columns protected by an active dynamic data masking policy
BA mixed result where rows associated with DATA_ADMIN ownership contain unmasked data and all other rows contain masked placeholders
CThe masked placeholder values permanently written into the new table based on PIPELINE_ROLE's masking policy context at query execution time
DThe original unmasked email addresses, because CTAS operations perform a server-side data movement that bypasses query-time masking policy evaluation
Explanation
Dynamic data masking is applied at query execution time based on the role of the session executing the query — data remains unchanged at rest, but query results reflect only what the executing role is authorized to see. When CTAS runs under PIPELINE_ROLE, which has no masking policy exemption, Snowflake applies the masking policy to the SELECT and the masked placeholder values are returned. Those masked values are then permanently written into the new intermediate table. This is a critical data governance risk: downstream processes — including those running as DATA_ADMIN — will only see the already-masked values when querying the intermediate table because the original email addresses were never stored there. CTAS does not bypass masking policies; no special server-side exception exists for internal pipeline operations. Masking policies never block CTAS or produce NULL values; the operation executes successfully and materializes whatever the executing role can see. Row ownership has no bearing on masking policy evaluation; the executing session role context is the sole determinant of visibility.
2. A performance engineer at Contoso Analytics is investigating slow query times on a medium-sized virtual warehouse used for ad-hoc analytical workloads. Query profiling reveals that the slowness is concentrated in a small percentage of queries performing large table scans with highly variable, unpredictable scan ranges — filtering across billions of rows with different WHERE clause conditions on each execution. The remaining workload completes within normal latency bounds. Which Snowflake feature should the engineer enable to target this specific performance pattern with minimal cost impact on the broader workload? (Select one!)
AConvert the warehouse to a multi-cluster configuration with economy auto-scaling to provide additional parallel compute for large scan queries
BIncrease the warehouse size from Medium to Large to allocate more compute nodes across all queries on the warehouse
CApply automatic clustering to the target tables using a clustering key aligned with the most frequently used filter columns
DEnable the Query Acceleration Service on the warehouse to offload portions of eligible large-scan queries to serverless compute resources
Explanation
The Query Acceleration Service (QAS) is specifically designed for warehouses where a subset of queries have large, irregular scan patterns that are disproportionately slow — exactly the scenario described. QAS offloads scan-intensive portions of eligible queries to serverless compute resources that scale independently of the warehouse, improving performance for those specific queries without requiring a permanent warehouse size change that would increase costs for the entire workload. Multi-cluster warehouses address queue-based concurrency bottlenecks where many simultaneous queries are waiting for available slots, which is not the problem described here. Increasing the warehouse size applies uniformly to all queries on the warehouse and would raise costs across the board while providing limited benefit specifically for irregular, ad-hoc scan patterns. Automatic clustering improves scan efficiency when queries consistently filter on a predictable and stable set of columns, but it does not help when filter conditions are highly variable and unpredictable across executions.
3. A data platform administrator at Contoso Financial is investigating why business analysts report slow query response times during peak hours. Querying ACCOUNT_USAGE.WAREHOUSE_LOAD_HISTORY for the REPORTING_WH warehouse reveals that AVG_RUNNING is consistently near 1.0 while AVG_QUEUED_LOAD averages 2.8 during business hours. What do these metrics indicate, and which action should the administrator take? (Select one!)
AAVG_QUEUED_LOAD of 2.8 indicates that on average 2.8 queries are waiting in the concurrency queue during each measurement interval; because AVG_RUNNING shows the single cluster is already fully occupied processing queries, enabling multi-cluster warehouses to scale out horizontally will absorb the excess concurrent demand
BAVG_RUNNING near 1.0 confirms the warehouse is executing queries at full compute utilization; scaling up to a larger warehouse size will directly resolve the queuing by enabling faster per-query execution and clearing the backlog
CAVG_QUEUED_LOAD measures warehouse credit consumption per interval; a value of 2.8 exceeds the standard billing threshold and the administrator should configure a resource monitor to cap spending on the warehouse
DBoth AVG_RUNNING and AVG_QUEUED_LOAD represent cumulative I/O throughput values measured in gigabytes; a combined value under 4.0 is within normal range for a busy analytical warehouse and no remediation is required
Explanation
WAREHOUSE_LOAD_HISTORY records load metrics as ratios of cumulative query-state time to total interval duration. AVG_RUNNING near 1.0 means the warehouse cluster is consistently busy executing queries throughout each measurement interval — it is processing work at full capacity. AVG_QUEUED_LOAD of 2.8 reveals that on average 2.8 queries are waiting in the concurrency queue at any given second during the interval, a clear sign that the single cluster cannot serve all simultaneous analyst requests. Because the bottleneck is concurrency (many users submitting queries at the same time) rather than query complexity (individual queries are completing once started), the correct remedy is horizontal scaling: enabling multi-cluster warehouses so Snowflake can automatically spin up additional clusters to absorb the excess concurrent load. Scaling up to a larger warehouse size improves per-query resource availability — useful when individual queries are slow — but a single larger cluster does not increase the number of queries that can execute simultaneously, so queuing persists. AVG_QUEUED_LOAD does not measure credit consumption or I/O throughput; credit usage is tracked in WAREHOUSE_METERING_HISTORY, and query-level I/O details appear in QUERY_HISTORY.
4. Fabrikam Corp's finance department manages several virtual warehouses dedicated to separate business units. They need individual compute spending limits on each warehouse rather than a single account-wide ceiling. When a warehouse reaches 80% of its monthly credit allocation the team should receive a notification; at 100% the warehouse should be suspended after running queries complete. Which resource monitor configuration satisfies these requirements? (Select one!)
ACreate one account-level resource monitor per cloud region with NOTIFY_USERS at 80% and SUSPEND_IMMEDIATE at 100%
BConfigure per-warehouse spending limits using ALTER WAREHOUSE SET CREDIT_QUOTA with threshold notifications defined inline
CCreate a single account-level resource monitor with NOTIFY at 80% and SUSPEND at 100%, then assign it to all warehouses simultaneously
DCreate separate warehouse-level resource monitors for each business unit warehouse, configuring a NOTIFY trigger at 80% and a SUSPEND trigger at 100%
Explanation
Warehouse-level resource monitors are assigned to specific virtual warehouses, enabling granular credit quotas and trigger actions independently for each warehouse. A NOTIFY trigger at 80% sends an alert to designated users, and a SUSPEND trigger at 100% gracefully suspends the warehouse after currently running queries finish. Account-level resource monitors track aggregate consumption across all warehouses and cannot enforce per-warehouse granularity. CREDIT_QUOTA is not a parameter configurable directly on a virtual warehouse object via ALTER WAREHOUSE. Account-level monitors cannot be scoped per business unit or per region — they are account-wide constructs.
5. A cloud architect at Northwind Finance is planning to use Snowflake failover groups to replicate users, roles, and resource monitors across two accounts for business continuity. The architect's current Snowflake deployment runs on Enterprise Edition. Which statement accurately describes the edition requirement for replicating users, roles, and resource monitors using failover groups? (Select one!)
AStandard Edition supports all replication and failover group features without any edition upgrade
BAll Snowflake editions support failover groups for account object replication; only Tri-Secret Secure requires Business Critical Edition
CBusiness Critical Edition or higher is required to replicate account-level objects such as users, roles, and resource monitors using failover groups
DEnterprise Edition fully supports failover groups, including replication of users, roles, and resource monitors across accounts
Explanation
Replicating account-level objects such as users, roles, and resource monitors through failover groups requires Business Critical Edition or higher. While database and share replication is available across all Snowflake editions, object replication — including users, roles, resource monitors, and the failover promotion capability that allows a secondary to be promoted to primary with read-write access — is restricted to Business Critical and above. Enterprise Edition alone does not satisfy this requirement for object replication via failover groups. Standard Edition does not support failover groups at all. The claim that all editions support account object replication is incorrect; Business Critical is the minimum edition for these advanced failover and object replication capabilities.
More Snowflake Practice Exams
SnowPro Advanced: Data Analyst (DAA-C01)
DAA-C01 · 600 questions
SnowPro Specialty: Gen AI (GES-C01)
GES-C01 · 600 questions
SnowPro Specialty: Native Apps (NAS-C01)
NAS-C01 · 600 questions
SnowPro® Advanced: Data Scientist (DSA-C03)
DSA-C03 · 600 questions
SnowPro® Specialty: Snowpark (SPS-C01)
SPS-C01 · 599 questions
SnowPro Advanced: Data Engineer (DEA-C02)
DEA-C02 · 597 questions
$17.99
One-time access to this exam
600 questions (6 practice exams' worth)
Unlimited timed exam simulations
Or $15/mo for all 253 exams
Detailed explanations
Free preview stays available