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 performance engineer at Adatum Analytics operates a Snowflake X-Large warehouse that supports a team of data scientists running ad-hoc queries involving large table scans with highly selective WHERE clause filters and complex multi-column GROUP BY aggregations on fact tables containing hundreds of millions of rows. Despite the large warehouse size, individual queries frequently take several minutes to execute. The engineer needs to improve performance for these specific query patterns without permanently resizing the warehouse or configuring multi-cluster settings. Which Snowflake feature should the engineer enable on the warehouse? (Select one!)
AMulti-cluster warehouse with the Economy scaling policy to handle burst demand
BWarehouse result set caching to avoid re-executing repeated analytical queries
CQuery Acceleration Service configured with an appropriate maximum scale factor
DAutomatic Clustering on the most frequently scanned columns in the fact tables
Explanation
Query Acceleration Service (QAS) is the correct feature for improving the performance of large scan queries with selective filters and complex aggregations. QAS offloads eligible portions of query workloads to serverless compute resources managed by Snowflake, supplementing the warehouse without requiring permanent resizing. It specifically targets the query patterns described: large table scans, highly selective predicates, and complex aggregations. A maximum scale factor parameter controls how much additional serverless compute QAS can consume relative to the warehouse size, providing cost governance. Multi-cluster warehouses address concurrency bottlenecks caused by many simultaneous users queuing for compute resources, not slow individual query execution on large data volumes. Automatic Clustering can reduce data scanned for queries that filter on defined clustering keys, but it requires identifying appropriate clustering keys for each table, incurs ongoing maintenance costs, and is less targeted than QAS for variable ad-hoc query patterns across many tables. Result set caching only benefits subsequent executions of identical queries, providing no benefit for the varied ad-hoc analytical workloads typical of data science teams.
2. Contoso Corp's platform team notices that their ANALYTICS_WH virtual warehouse has a high number of queries waiting during peak business hours from 9 AM to 12 PM but runs at low utilization during off-peak hours. The warehouse is currently configured as a Single-Cluster X-Large. Before making configuration changes, the team wants to determine how many queries are actively executing versus waiting in the queue and whether this pattern is consistent across days. Which Snowflake feature should they use to analyze this workload pattern? (Select one!)
AWarehouse Load Monitoring in Snowsight, which displays active query count, queued query count, and blocked query count over a selectable time range
BQUERY_HISTORY view in SNOWFLAKE.ACCOUNT_USAGE filtered by EXECUTION_STATUS equal to QUEUED to manually count waiting queries for each hour
CQuery Acceleration Service eligibility dashboard, which identifies individual queries that would benefit from elastic compute scaling
DResource Monitor credit usage notifications, which alert administrators when the warehouse exceeds the configured credit consumption threshold
Explanation
Warehouse Load Monitoring in Snowsight is the purpose-built feature for understanding warehouse compute capacity utilization over time. It displays a time-series chart showing the count of actively running queries, queued queries waiting for compute resources, and blocked queries at any point within the selected time window. This directly answers whether the warehouse is at capacity during peak hours and whether adding compute nodes via multi-cluster warehouse configuration would reduce queuing. QUERY_HISTORY in ACCOUNT_USAGE can be queried to find queued queries but requires custom SQL, lacks visual trend analysis, and does not provide the same real-time granularity needed for capacity planning. Query Acceleration Service eligibility focuses on optimizing individual outlier queries with highly variable execution times, not overall queue depth caused by general warehouse saturation. Resource Monitor notifications track credit consumption against a budget threshold, measuring cost rather than compute capacity or queue depth.
3. A senior data engineer at Relecloud Financial is designing an ingestion architecture for a stock trading system that emits thousands of row-level events per second from a custom Java application. The solution must achieve sub-second ingestion latency, support parallel ingestion across multiple application threads, and allow each thread to independently track its ingestion progress for fault tolerance and resumption after failures. Which two Snowflake capabilities together best satisfy all three requirements? (Select two!)
Multiple correct answersAUse classic Snowpipe with Amazon SQS event notifications to trigger file-based ingestion
BUse Snowpipe Streaming via the Snowflake Ingest SDK to write rows directly to Snowflake tables
CCreate multiple independent channels within a Snowpipe Streaming client, one per application thread, each maintaining its own offset token
DUse a Snowflake Task with a COPY INTO statement scheduled every 10 seconds to process staged files
EUse the Kafka Connector for Snowflake configured in Snowpipe mode for parallel file-based ingestion
Explanation
Snowpipe Streaming via the Snowflake Ingest SDK enables direct row-level ingestion with sub-second latency by bypassing the file-staging step required by classic Snowpipe. Channels are the fundamental unit of parallelism and fault tolerance in Snowpipe Streaming — each application thread creates and owns its own independent channel, and each channel maintains its own offset token that tracks the last successfully committed row. This allows individual threads to independently resume ingestion from their last committed position after failures without affecting other threads, satisfying the fault tolerance requirement. Classic Snowpipe depends on file staging and SQS notifications, which introduces latency measured in minutes rather than sub-seconds. Scheduled tasks with COPY INTO process files at fixed intervals and cannot achieve sub-second latency. The Kafka Connector in Snowpipe mode also uses file-based ingestion stages and does not achieve sub-second row-level latency.
4. A security administrator at Northwind Healthcare is designing a Snowflake authentication strategy that enforces MFA for all interactive users while allowing automated service accounts to authenticate without MFA prompts. The service accounts use key pair authentication. Which statement accurately describes how Snowflake MFA enforcement behaves? (Select one!)
AMFA enforcement applies to all Snowflake authentication methods including key pair and OAuth when enabled at the account level
BService accounts must be assigned the LEGACY_SERVICE user type to bypass MFA requirements when using key pair authentication
CMFA can be selectively configured to apply only to SERVICE user types using the USER_TYPE parameter in the security policy
DMFA using Duo Security applies to username/password authentication only and is not enforced for key pair, OAuth, or federated authentication methods
Explanation
Snowflake's built-in MFA, powered by Duo Security via Duo Push, applies exclusively to username/password authentication. Key pair authentication, OAuth, and federated/SAML authentication are not subject to MFA enforcement by design. This allows administrators to enforce MFA for interactive human users while automated service accounts using key pair authentication operate without MFA prompts. There is no mechanism to selectively apply MFA per user type through a USER_TYPE parameter. LEGACY_SERVICE user type is for backward compatibility with existing service accounts and does not control MFA behavior — the authentication method itself determines whether MFA applies.
5. Graphic Design Institute's DevOps team needs to rotate the RSA key pair used by their data pipeline service account without causing any pipeline downtime. The service account currently has RSA_PUBLIC_KEY configured. Which sequence of steps correctly performs a zero-downtime key pair rotation? (Select one!)
AGenerate a new key pair, create a new service account with the new public key, update all pipeline clients to use the new account credentials, then drop the old service account
BGenerate a new key pair, set the new public key as RSA_PUBLIC_KEY_2 using ALTER USER, update all pipeline clients to use the new private key, then unset RSA_PUBLIC_KEY and promote RSA_PUBLIC_KEY_2
CGenerate a new key pair, disable the service account with ALTER USER SET DISABLED = TRUE, set RSA_PUBLIC_KEY to the new public key, re-enable the account, then update pipeline clients
DGenerate a new key pair, immediately replace RSA_PUBLIC_KEY with the new public key using ALTER USER, then update all pipeline clients to use the new private key
Explanation
Zero-downtime key pair rotation in Snowflake leverages the dual key slot design by setting the new public key as RSA_PUBLIC_KEY_2 while RSA_PUBLIC_KEY remains active. Both keys are valid simultaneously during the transition window, giving pipeline clients time to update their private key configuration without any service interruption. Once all clients are confirmed to be using the new private key, the old RSA_PUBLIC_KEY can be unset and RSA_PUBLIC_KEY_2 promoted to RSA_PUBLIC_KEY. Directly replacing RSA_PUBLIC_KEY immediately invalidates the current private key, causing authentication failures for any client that has not yet been updated. Disabling the account causes immediate downtime for all pipeline operations during the rotation window. Creating a new service account loses all existing privilege grants and requires re-authorization across every object in the environment.
More Snowflake Practice Exams
SnowPro Specialty: Gen AI (GES-C01)
GES-C01 · 600 questions
SnowPro Specialty: Native Apps (NAS-C01)
NAS-C01 · 600 questions
SnowPro® Specialty: Snowpark (SPS-C01)
SPS-C01 · 599 questions
SnowPro Advanced: Architect (ARA-C01)
ARA-C01 · 592 questions
SnowPro Advanced: Data Analyst (DAA-C01)
DAA-C01 · 600 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
Yours forever — no subscription
Detailed explanations
Free preview stays available