Home Certifications FAQ Partners Blog

·EN·DE·FR·ES·PT

Snowflake · SF-ADM · Advanced

SnowPro Advanced: Administrator (ADA-C02) — Practice Questions and Mock Exam

Prepare for SF-ADM with original practice questions and clear answer explanations. Ask Alex, your AI tutor, when you need more detail, use your results to identify topics to review, and practice your pacing with timed mock exams.

Start practicing SF-ADM free Buy SF-ADM access for $29.99

Buy SF-ADM access for $29.99 Start practicing SF-ADM free

65Mock exam questions

115minTime limit

750/ 1000Passing score

Checked against Snowflake · August 2026 · Current exam version

Overview

About the exam

The SnowPro Advanced: Administrator Certification (ADA-C02) validates expertise in Snowflake account administration, including managing and monitoring accounts, enforcing data security and compliance, handling database objects and virtual warehouses, performance tuning, data sharing via Marketplace and Exchange, and implementing disaster recovery and replication strategies. It covers the full operational scope of a Snowflake administrator.

This certification is designed for database administrators, cloud administrators, and data platform operators with two or more years of Snowflake administration experience. It demonstrates the ability to maintain secure, performant, and compliant Snowflake environments at enterprise scale and is essential for roles managing production deployments.

Try the practice preview

Try five SF-ADM questions

Try five practice questions from the app’s current SnowPro Advanced: Administrator (ADA-C02) question bank, with answers and explanations.

Snowflake Security, Role-Based Access Control (RBAC), and User Administration1 / 5

Which system role is dedicated to creating and managing custom account roles under Snowflake role-management best practices?

AlexFull explanation from Alex

Snowflake separates administration duties: USERADMIN creates and manages users and roles it owns; SECURITYADMIN manages grants through MANAGE GRANTS; SYSADMIN owns and manages warehouses, databases, and database objects. For custom roles, Snowflake recommends building a role hierarchy aligned to business functions and assigning the top custom role to SYSADMIN so system administrators can manage objects owned by those roles, while user and role administration remains with USERADMIN.

Sourcedocs.snowflake.com

Data and Object Management2 / 5

Which table function does a task owner query to retrieve the credit usage of a specific serverless task?

AlexFull explanation from Alex

Serverless task compute is not attributed to any warehouse, so warehouse metering views simply do not see it — a common reason administrators conclude a task is free. SERVERLESS_TASK_HISTORY is the dedicated accounting surface, with credits_used per run. TASK_HISTORY, by contrast, reports execution state and scheduling rather than credit consumption, so it answers 'did it run' but not 'what did it cost'.

Sourcedocs.snowflake.com

Data Sharing and Snowflake Marketplace3 / 5

What is a direct share in Snowflake?

AlexFull explanation from Alex

A direct share is a named Snowflake object that allows a data provider to grant read-only access to specific database objects (tables, secure views, UDFs) to designated consumer accounts in the same region. No data is copied—consumers query data in place, paying only for compute. A file transfer mechanism is incorrect; shares use Snowflake's metadata layer, not file transfers. A cross-cloud replication tool describes replication groups, not shares. A data marketplace listing describes Snowflake Marketplace listings, which are distinct from direct account-to-account shares. Ref: docs.snowflake.com/en/user-guide/data-sharing-intro.

Sourcedocs.snowflake.com

Account Management & Data Governance4 / 5

At which levels can a resource monitor be set?

AlexFull explanation from Alex

Resource monitors in Snowflake track credit usage and can be set at two levels: account level (monitoring all warehouses, one per account) and individual warehouse level (monitoring specific warehouses). Trigger actions include NOTIFY (alert only), SUSPEND (finish queries then suspend), and SUSPEND_IMMEDIATE (cancel and suspend). Database/schema level is incorrect—resource monitors do not apply to storage objects. User/role level and stage/table level are not valid monitor levels. Only ACCOUNTADMIN can create resource monitors by default. Ref: docs.snowflake.com/en/user-guide/resource-monitors, docs.snowflake.com/en/sql-reference/sql/create-resource-monitor.

Sourcedocs.snowflake.com

Performance Monitoring & Tuning5 / 5

Which parameter controls query result caching?

AlexFull explanation from Alex

USE_CACHED_RESULT (default TRUE) controls whether Snowflake returns cached results for repeated identical queries. When enabled, if the same query is re-executed within 24 hours and underlying data hasn't changed, Snowflake returns the persisted result without consuming warehouse compute. A (ENABLE_RESULT_CACHE) is not a valid Snowflake parameter. C (RESULT_CACHE_ENABLED) is similarly fabricated. D (CACHE_QUERY_RESULTS) does not exist. The parameter can be set at account or session level via ALTER SESSION SET USE_CACHED_RESULT = FALSE. Cache reuse requires exact query text match, unchanged data, and no non-deterministic functions like RANDOM() or UUID_STRING(). Ref: docs.snowflake.com/en/user-guide/querying-persisted-results

Sourcedocs.snowflake.com

Create a free account

Question pool

425 practice questions

The Pass-IT question pool gives you material to practice for SF-ADM. A Pass-IT mock exam uses 65 questions and a 115-minute time limit; these are practice settings.

Pool details: SF-ADM

Passing score750 / 1,000

as published by Snowflake

Objectives in the guide24 objectives listed in the official guide

across 6 domains in the official exam guide

Pool size425 questions

= The pool size is equivalent to 6 sets of 65 questions; this does not mean that each mock exam uses a separate set.

Blueprint domains6 domains in the exam blueprint

Snowflake Security, Role-Based Access Control (RBAC), and User Administration 131 · Account Management & Data Governance 77 · Data and Object Management 63 · Performance Monitoring & Tuning 85 · Data Sharing and Snowflake Marketplace 31 · Disaster Recovery, Backup & Data Replication 38

Recorded as checked against sources425 of 425

questions recorded as having their answer, options, and explanation checked against official Snowflake documentation

How questions are made →

Exam domains

What's on the exam

Security, RBAC, and user administration carry the most weight at 31%, covering the built-in role hierarchy, custom role design, federated authentication and MFA, and network policy configuration. Performance monitoring and tuning follows at 20%, testing query profile analysis, caching behavior, DML concurrency, and cost management through resource monitors and the ACCOUNT_USAGE schema. Account management and data governance (18%) and data and object management (15%) cover the remaining operational core: organizational parameters, warehouse sizing, table and view design, and data masking or row-access policies.

Disaster recovery and data sharing close out the blueprint at 9% and 7%, still testing replication groups, failover, Time Travel, and Marketplace listing management in depth despite the low weight. The split reflects how a production administrator spends their week: more time granting and auditing access and chasing slow queries than configuring outbound data shares or building a DR runbook from scratch.

Exam blueprint: SF-ADM

Snowflake Security, Role-Based Access Control (RBAC), and User Administration31%

Configure and manage roles, privileges, network policies, SSO, MFA, and user administration at enterprise scale.

≈ 25 h

Account Management & Data Governance18%

Manage account parameters, organizations, resource monitors, data governance policies, and tagging.

≈ 14 h

Data and Object Management15%

Manage databases, schemas, tables, views, stages, and other Snowflake objects. Handle storage and retention.

≈ 12 h

Performance Monitoring & Tuning20%

Monitor warehouse utilization, query performance, resource consumption, and optimize system configuration.

≈ 16 h

Data Sharing and Snowflake Marketplace7%

Configure and manage secure data sharing, reader accounts, and Snowflake Marketplace listings.

≈ 6 h

Disaster Recovery, Backup & Data Replication9%

Implement failover, replication, Time Travel, Fail-safe, and business continuity strategies.

≈ 7 h

Format

Exam format and question types

The exam consists of 65 questions in 115 minutes, drawn from multiple-choice, multiple-select, and interactive formats such as matching and drag-and-drop. Most items work from an operational scenario: a described account, role structure, or performance issue that you resolve by choosing the right SQL statement, parameter, or policy setting. At roughly 1.8 minutes per question, the pace rewards candidates who don't have to stop and work out the role hierarchy from scratch.

Question types: SF-ADM

Multiple Choice70%

Select the single answer that best meets the question’s requirements.

Multiple Response30%

Select multiple answers. Follow the question’s instructions on how many to choose.

See Snowflake for official question-format information. The shares shown describe the Pass-IT practice pool; they do not establish the proportions on the official exam.

Planning

Preparing for SF-ADM

Delivered by online proctoring or at an onsite testing center, in English. The certification expires two years after your issue date; you recertify through the Snowflake Continuing Education program with an eligible instructor-led training course or an equivalent or higher-level SnowPro certification.

Preparation and logistics: SF-ADM

Preparation

Illustrative study time50–120 h

illustrative planning range: 50 h with relevant experience to 120 h when starting out; your needs may fall outside this range

LevelAdvanced

Recommended backgroundSnowPro Core Certified. 2 or more years of hands-on Snowflake administration experience in production.

Taking and maintaining the certification

DeliveryOnline proctored or onsite testing centers.

Retake policyLimit of 4 attempts in a 12-month period. After three attempts Snowflake recommends attending an onsite Snowflake training course. Each registration requires the full registration fee.

Certification validity2 years

Snowflake certifications expire two years after the certification issue date. Recertify through the Snowflake Continuing Education (CE) program: complete an eligible Snowflake Instructor-Led (ILT) training course, or earn an equivalent or higher-level SnowPro certification. A valid certification is required to take part in the CE program.

Official guideView on provider site

Study notes

Common pitfalls

Topics to review: SF-ADM

01Role Hierarchy
Not understanding the built-in role hierarchy (ACCOUNTADMIN > SECURITYADMIN > USERADMIN, ACCOUNTADMIN > SYSADMIN) and how custom roles inherit privileges leads to access control errors.
02Network Policies
Confusing account-level network policies with user-level policies and not knowing how IP allow/block lists interact causes security configuration question mistakes.
03Resource Monitors
Not knowing the difference between notify, suspend, and suspend-immediately actions on resource monitors — and that they only track credit usage, not storage — leads to cost management errors.
04Data Masking Policies
Mixing up Dynamic Data Masking (column-level, role-based) with Row Access Policies (row-level filtering) and not understanding policy assignment inheritance causes governance mistakes.
05Account Replication
Confusing database replication with account-level failover groups and not understanding which objects can be replicated leads to disaster recovery planning errors.

Practice with questions and explanations in Pass-IT →

Questions

Frequently asked questions

How long is the SnowPro Advanced: Administrator (ADA-C02) exam?

The SnowPro Advanced: Administrator (ADA-C02) exam has 65 questions and a 115-minute time limit.

What is the passing score for SnowPro Advanced: Administrator (ADA-C02)?

The passing score for the SnowPro Advanced: Administrator (ADA-C02) exam is 750 / 1000.

Which pitfalls should I review when preparing for SnowPro Advanced: Administrator (ADA-C02)?

Topics to review include Role Hierarchy, Network Policies, Resource Monitors, Data Masking Policies, Account Replication. Work through examples to check that you understand the distinctions and can explain your answer.

How is the SnowPro Advanced Administrator exam weighted?

Security, role-based access control and user administration dominates at 31%, followed by performance monitoring and tuning at 20% and account management and data governance at 18%. Data and object management takes 15%, disaster recovery and replication 9% and data sharing 7%. Access control alone is nearly a third of the exam.

Do you need SnowPro Core before the Advanced Administrator exam?

Yes. Snowflake requires SnowPro Core certification for every advanced exam, and this one additionally assumes two or more years of hands-on production administration. The catalog budget is around 80 hours on top of that. This is a real gate rather than a recommendation, unlike most vendors in our catalog.

How do you renew the Advanced Administrator certification?

Snowflake certifications expire two years after the issue date, and recertification runs through the continuing-education programme. That means an eligible instructor-led training course, or an equivalent or higher SnowPro certification. You have to hold a valid certification to use the programme at all.

What happens if you fail the Advanced Administrator exam?

You are limited to four attempts in a 12-month period. After three attempts Snowflake recommends an onsite training course before trying again, which is a stronger signal than the waiting periods other vendors use.

One certification, 12 months

Practice for SF-ADM

Focus your practice on one certification, or choose Pro to practice across all certifications.

Buy SF-ADM access for $29.99

Start a free practice sessionTry the first 20 questions without a card to see whether the practice suits you.

For eligible purchases: money-back guarantee if you fail your exam.

View guarantee terms →