100+ Free SnowPro Advanced Administrator Practice Questions

Pass your SnowPro Advanced: Administrator (ADA-C01) exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately

100+ Questions

100% Free

1 / 10

Question 1

Score: 0/0

Which Snowflake role is the highest-privileged built-in role and the only one that can manage account-level parameters and billing-related settings by default?

SYSADMIN

SECURITYADMIN

ACCOUNTADMIN

ORGADMIN

to track

2026 Statistics

Key Facts: SnowPro Advanced Administrator Exam

Live Exam Questions

Snowflake

115 min

Time Limit

Snowflake

750/1000

Passing Score

Scaled

$375

Exam Fee

$300 in India

30-35%

Largest Domain

Security & RBAC

2 years

Certification Valid

Renew via SnowPro Core

SnowPro Advanced Administrator (ADA-C01) is a 65-question Snowflake exam delivered in 115 minutes with a passing scaled score of 750/1000. The blueprint covers Snowflake Security/RBAC/User Administration (30-35%), Account Management and Data Governance (20-25%), Performance Monitoring and Tuning (20-25%), Data Sharing/Data Exchange/Marketplace (10-15%), and Disaster Recovery/Backup/Replication (10-15%). Snowflake requires an active SnowPro Core certification as a prerequisite and recommends 2+ years of hands-on administrator experience. Exam fee is $375 USD per attempt ($300 USD in India). Certification is valid for 2 years; renewal requires an active SnowPro Core certification.

Sample SnowPro Advanced Administrator Practice Questions

Try these sample questions to test your SnowPro Advanced Administrator exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1Which Snowflake role is the highest-privileged built-in role and the only one that can manage account-level parameters and billing-related settings by default?

A.SYSADMIN

B.SECURITYADMIN

C.ACCOUNTADMIN

D.ORGADMIN

Explanation: ACCOUNTADMIN sits at the top of the built-in role hierarchy and is the only role that can manage account-level parameters and billing by default. SYSADMIN owns object hierarchies, SECURITYADMIN manages roles and grants, and ORGADMIN manages an organization across multiple accounts but does not own account-internal billing controls.

2Which built-in role is intended to manage roles and grants without owning the underlying objects?

A.SECURITYADMIN

B.SYSADMIN

C.ACCOUNTADMIN

D.PUBLIC

Explanation: SECURITYADMIN can create, alter, and drop roles and manage grants without needing ownership of the affected objects. SYSADMIN owns the object hierarchy. ACCOUNTADMIN can also do it, but the recommended least-privilege role for grant management is SECURITYADMIN.

3Which Snowflake construct grants privileges automatically to objects that will be created in the future?

A.FUTURE GRANTS

B.REVOKE

C.SHOW GRANTS

D.Object ownership transfer

Explanation: GRANT ... ON FUTURE objects automatically applies privileges to objects of the specified type created later in the schema or database. REVOKE removes grants, SHOW GRANTS lists them, and ownership transfer changes the OWNER role only.

4What is the maximum DATA_RETENTION_TIME_IN_DAYS for permanent tables on Standard Edition?

A.0

B.1

C.7

D.90

Explanation: Standard Edition supports a maximum of 1 day of Time Travel for permanent tables. Enterprise Edition and above support up to 90 days. Transient and temporary tables max at 1 day on any edition.

5How long is Fail-safe retention for permanent tables in Snowflake?

A.1 day

B.7 days, non-configurable

C.90 days, configurable

D.Indefinite

Explanation: Fail-safe is a non-configurable 7-day disaster-recovery retention period that begins after Time Travel ends, available only to Snowflake Support, not to users. Transient and temporary tables have no Fail-safe.

6Which warehouse property limits how aggressively additional clusters spin up under load on a multi-cluster warehouse?

A.AUTO_SUSPEND

B.SCALING_POLICY

C.WAREHOUSE_SIZE

D.AUTO_RESUME

Explanation: SCALING_POLICY (STANDARD or ECONOMY) controls how multi-cluster warehouses spin up additional clusters: STANDARD prioritizes responsiveness, ECONOMY prioritizes credit efficiency. AUTO_SUSPEND/AUTO_RESUME control idle handling, WAREHOUSE_SIZE controls compute size per cluster.

7Which warehouse type provides additional memory per node for memory-intensive workloads such as Snowpark ML training?

A.Standard warehouse

B.Snowpark-optimized warehouse

C.Search optimization warehouse

D.Reader account warehouse

Explanation: Snowpark-optimized warehouses use larger nodes with more memory per warehouse, designed for memory-bound workloads. Standard warehouses are general-purpose. There is no 'search optimization warehouse' type, and reader accounts are for sharing.

8Which construct caps the credits a warehouse can consume in a billing interval?

A.Resource monitor

B.Network policy

C.Masking policy

D.Secure share

Explanation: Resource monitors set credit thresholds (e.g., 80% notify, 100% suspend) per warehouse or at the account level. Network policies restrict source IPs, masking policies obscure column data, and shares expose data to consumer accounts.

9Which Snowflake feature allows zero-storage-cost copies of databases or tables for development environments?

A.Zero-Copy Cloning

B.Time Travel

C.Snowpipe

D.Search Optimization Service

Explanation: Zero-Copy Cloning produces a metadata-only clone that initially shares micro-partitions with the source. Storage grows only as the clone diverges. Time Travel is point-in-time queryability, Snowpipe is ingestion, and SOS accelerates lookups.

10Which view in ACCOUNT_USAGE shows a per-warehouse credit consumption history?

A.WAREHOUSE_METERING_HISTORY

B.QUERY_HISTORY

C.LOGIN_HISTORY

D.ACCESS_HISTORY

Explanation: WAREHOUSE_METERING_HISTORY exposes hourly credit usage per warehouse. QUERY_HISTORY is per-query, LOGIN_HISTORY tracks logins, and ACCESS_HISTORY tracks column-level access.

About the SnowPro Advanced Administrator Exam

The SnowPro Advanced: Administrator (ADA-C01) certification validates the ability to manage Snowflake accounts and the Snowflake AI Data Cloud at scale. It covers organization and account architecture, RBAC and user administration, warehouse sizing and resource monitors, performance and cost monitoring with ACCOUNT_USAGE views, secure data sharing and the Snowflake Marketplace, and disaster recovery via database replication and failover groups.

Assessment

Multiple-choice and multiple-select items on the live exam

Time Limit

115 minutes

Passing Score

750/1000 (scaled)

Exam Fee

$375 USD (Snowflake / Pearson VUE)

SnowPro Advanced Administrator Exam Content Outline

30-35%

Snowflake Security, RBAC, and User Administration

Authentication (password policies, MFA, SAML SSO, OAuth, key pair, SCIM), RBAC hierarchy (ACCOUNTADMIN, SYSADMIN, SECURITYADMIN, USERADMIN, PUBLIC), custom roles, future grants vs explicit grants, and least-privilege design.

20-25%

Account Management and Data Governance

ORGADMIN and multi-account organizations, edition selection (Standard, Enterprise, Business Critical, VPS), DATA_RETENTION_TIME_IN_DAYS, transient vs permanent vs temporary tables, masking policies, row access policies, tagging, and classification.

20-25%

Performance Monitoring and Tuning

Warehouse sizing (XS-6XL), multi-cluster scaling policies (STANDARD vs ECONOMY), Snowpark-optimized warehouses, Query Acceleration Service, automatic clustering, search optimization service, materialized views, query profile interpretation, ACCOUNT_USAGE views, resource monitors and credit governance.

10-15%

Data Sharing, Data Exchange, and Snowflake Marketplace

Secure Data Sharing (providers and consumers), shares and listings, reader accounts, cross-cloud and cross-region sharing, the Snowflake Marketplace, and private exchanges for partner ecosystems.

10-15%

Disaster Recovery, Backup, and Data Replication

Time Travel (0-90 days, Enterprise+), Fail-safe (7 days, non-configurable), Zero-Copy Cloning, database replication, failover groups for cross-region/cross-cloud DR, replication latency monitoring, and recovery time and recovery point planning.

How to Pass the SnowPro Advanced Administrator Exam

What You Need to Know

Passing score: 750/1000 (scaled)
Assessment: Multiple-choice and multiple-select items on the live exam
Time limit: 115 minutes
Exam fee: $375 USD

Keys to Passing

Complete 500+ practice questions
Score 80%+ consistently before scheduling
Focus on highest-weighted sections
Use our AI tutor for tough concepts

SnowPro Advanced Administrator Study Tips from Top Performers

1Study to the official weights and prioritize Security/RBAC because it is the largest domain and weaves into nearly every other topic.

2Memorize the role hierarchy (ACCOUNTADMIN, SYSADMIN, SECURITYADMIN, USERADMIN, PUBLIC) and when to use ORGADMIN.

3Practice configuring resource monitors with credit limits, suspend actions, and notifications for cost governance.

4Know when to choose a Standard vs Snowpark-optimized warehouse, and how STANDARD vs ECONOMY scaling policies behave under bursty workloads.

5Differentiate Time Travel (0-90 days, Enterprise+) from Fail-safe (7 days, non-configurable) and how they apply to permanent, transient, and temporary tables.

6Practice secure data sharing patterns: shares, listings, reader accounts, and cross-cloud sharing with replication considerations.

7Run scenario-based questions about replication and failover groups, including replication latency monitoring and DR runbooks.

8Use ACCOUNT_USAGE views in hands-on labs (QUERY_HISTORY, LOGIN_HISTORY, ACCESS_HISTORY, TASK_HISTORY, WAREHOUSE_METERING_HISTORY) to internalize cost and audit queries.

9Confirm SnowPro Core (COF-C02) is active before scheduling and remember the 2-year validity and 7-day retake rule.

Frequently Asked Questions

What is the format of the SnowPro Advanced Administrator exam?

ADA-C01 is a 65-question exam delivered in 115 minutes through Pearson VUE, available online proctored or onsite. The exam includes multiple-choice and multiple-select scenario items. Snowflake may include unscored experimental items that do not affect your final score, and results are reported on a 0-1000 scaled scoring system.

What score do I need to pass ADA-C01?

You need a scaled score of 750 out of 1000 to pass. Snowflake uses scaled scoring, so the percent of items you answer correctly does not map cleanly to 75 percent. The right strategy is to target consistent strength across all five domains rather than over-investing in a single area such as RBAC.

What are the official ADA-C01 domain weights?

The blueprint covers Snowflake Security, RBAC, and User Administration (30-35%), Account Management and Data Governance (20-25%), Performance Monitoring and Tuning (20-25%), Data Sharing/Data Exchange/Marketplace (10-15%), and Disaster Recovery/Backup/Replication (10-15%). Security and RBAC is the single heaviest domain.

Do I need a prerequisite to take ADA-C01?

Yes. Snowflake requires an active SnowPro Core certification (COF-C02) as a prerequisite for all SnowPro Advanced exams, including Administrator. Snowflake also recommends 2+ years of hands-on Snowflake administrator experience in production, plus proficiency with ANSI SQL and Snowflake-extended SQL.

How does ADA-C01 align with current 2026 Snowflake features?

Expect scenario items that reference current features such as ORGADMIN, replication and failover groups, Snowpark-optimized warehouses, Query Acceleration Service, hybrid tables for OLTP, dynamic tables, and managed Iceberg tables. Account Usage views like QUERY_HISTORY, LOGIN_HISTORY, ACCESS_HISTORY, and TASK_HISTORY remain core to monitoring workflows.

How much does the exam cost and what is the retake policy?

Advanced exams cost $375 USD per attempt, with discounted pricing of $300 USD for candidates testing in India. After a failed attempt, you must wait 7 calendar days before retaking. Snowflake allows up to 4 retakes of the same exam within a 12-month period, and each retake requires full payment.

How should I study for SnowPro Advanced Administrator?

Anchor your prep on the official blueprint and prioritize Security and RBAC. Practice ALTER WAREHOUSE statements, scaling policies, resource monitors, masking and row access policies, time travel windows by table type, replication and failover, and ACCOUNT_USAGE queries. Most candidates need 80-150 hours of study depending on prior production Snowflake admin experience.