A high-quality, authoritative exam is a long and tough climb — especially when your calendar is already full. PassCollection respects that reality: the ADA-C01 bank delivers 80 expert-verified practice questions covering the Snowflake SnowPro Advanced Administrator objectives, built for professionals short on time.
Snowflake ADA-C01 Exam Overview:
| Certification Vendor: | Snowflake |
|---|---|
| Exam Name: | SnowPro Advanced: Administrator Certification Exam |
| Exam Number: | ADA-C01 |
| Available Languages: | English |
| Real Exam Qty: | 65 |
| Passing Score: | 750 (scale 0-1000) |
| Exam Format: | Scenario-based, Multiple Choice, Multiple Select |
| Exam Duration: | 115 minutes |
| Exam Price: | $375 USD |
| Certificate Validity Period: | 2 years |
| Related Certifications: | SnowPro Core SnowPro Advanced: Security Engineer SnowPro Advanced: Architect |
| Recommended Training: | Snowflake Official Training |
| Exam Registration: | Pearson VUE Registration |
| Sample Questions: | ![]() |
| Exam Way: | Online proctored (OnVUE) or onsite at Pearson VUE test centers |
| Pre Condition: | Active SnowPro Core Certification; 2+ years hands-on Snowflake administration experience |
| Official Syllabus URL: | https://learn.snowflake.com/en/certifications/snowpro-advanced-administrator-c01/ |
Snowflake ADA-C01 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Virtual Warehouse & Performance | 15% | - Concurrency & resource monitoring - Query optimization & clustering - Warehouse sizing, scaling & monitoring |
| Data Sharing & Marketplace | 10% | - Secure data sharing & data exchanges - Marketplace provider & consumer management |
| Disaster Recovery & Replication | 10% | - Time Travel & Fail-safe configuration - Database & account replication - Backup & recovery strategies |
| Database & Object Administration | 20% | - Object lifecycle & permissions - Storage management & data types - Stages, file formats & external access |
| Security & Access Control | 25% | - Authentication, MFA & federation - Data security, masking & classification - Audit, compliance & SCIM integration - RBAC, roles & privileges design |
| Account Management & Governance | 20% | - Cost management & usage monitoring - Resource management & policies - Account configuration & organization setup |
What to Know About the ADA-C01 Exam and Our Services
According to the latest exam information, the ADA-C01 exam contains 65 questions and runs for 115 minutes minutes. Simulating that exact limit in practice builds the pacing a tough exam demands.
The Snowflake SnowPro Advanced Administrator blueprint centers on these domains:
- Security & Access Control (25%)
- Disaster Recovery & Replication (10%)
- Data Sharing & Marketplace (10%)
Further domains complete the official outline — the question bank covers every one.
Registration goes through the official channels below:
Pick a test center or online slot that suits your calendar, and book early — preparation goes smoother with a date in place.
Clear terms, no runaround. If you fail the corresponding exam within 60 days of purchase, send us a scanned copy of your enrollment slip and your official Score Report PDF within two days of the exam date; verified claims are refunded in full within seven days. Exclusions: exams taken within three days of purchase, candidate names that do not match the payer, and free or expired products. Prefer to switch tracks? Exchange your product for two others of equal value at no cost.
A team of IT experts and certified trainers with rich experience in the Snowflake SnowPro Advanced Administrator field writes it — and keeps it honest. Every answer is expert-verified, the content is checked continuously for updates, and each new ADA-C01 version is emailed to you free for 365 days. Compared with training institutions, the bank is affordable and self-paced; compared with guesswork, it is systematic. Download the free demo first, and if anything goes wrong — even a simple downloading problem — 24/7 customer assistance is one message away.
Snowflake lists these official training options for candidates:
Structured training plus consistent self-practice covers both depth and exam readiness.
Snowflake states the following prerequisites for the Snowflake SnowPro Advanced Administrator: Active SnowPro Core Certification; 2+ years hands-on Snowflake administration experience.
Confirm the current requirements on the official certification page before you register.
Currently, the ADA-C01 exam requires a passing score of 750 (scale 0-1000), with a registration fee of $375 USD. Snowflake sets both figures, so verify the latest on the official site before scheduling.
Upon successful payment, our system automatically sends the product to your mailbox — typically within about a minute — with an instant download link on screen. If nothing arrives within two hours, check your spam folder and contact our 24/7 customer assistance. Updates are free for 365 days: the moment a new version releases, the latest bank is sent to your email immediately, no matter when you purchased. A 50% renewal discount applies when the period ends.
Snowflake SnowPro Advanced Administrator Sample Questions:
.
Company A uses Snowflake to manage audio files of call recordings. Company A hired Company B, who also uses Snowflake, to transcribe the audio files for further analysis.
Company A's Administrator created a share.
What object should be added to the share to allow Company B access to the files?
- A. A secure view with a column for METADATA$FILENAME.
- B. A secure view with a column for the stage name and a column for the file path.
- C. A secure view with a column for file URLs.
- D. A secure view with a column for pre-signed URLs.
Correct Answer: D 🗳️
Explanation: Only visible for PassCollection members. You can sign-up / login (it's free).
A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business Critical edition. The minimum number of clusters is set to 2 and the maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.
Which solutions will address the issues happening once a month? (Select TWO).
- A. Increase the minimum number of clusters started in the multi-cluster configuration to 5.
- B. Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.
- C. Increase the multi-cluster maximum to 20 or more clusters.
- D. Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.
- E. Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.
Correct Answer: D,E 🗳️
Explanation: Only visible for PassCollection members. You can sign-up / login (it's free).
Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?
- A. alter user userl set TEMPORARY_MFA_BYPASS=1440;
- B. alter user userl set DISABLE_MFA=1440;
- C. alter user userl set HOURS_TO_BYPASS_MFA=24;
- D. alter user userl set MINS_TO_BYPASS_MFA=1440;
Correct Answer: D 🗳️
Explanation: Only visible for PassCollection members. You can sign-up / login (it's free).
A company has set up a new Snowflake account. An Identity Provider (IdP) has been configured for both Single Sign-On (SSO) and SCIM provisioning.
What maintenance is required to ensure that the SCIM provisioning process continues to operate without errors?
- A. The IdP Administrator must issue a REFRESH transaction at least once every six months to synchronize all users and roles.
- B. The Administrator must issue a POST RENEW call to the REST API at least once every six months.
- C. The OAuth Bearer Tokens have a lifespan of six months and must be regenerated prior to expiration.
- D. The IdP service account requires a new RSA key pair to be generated every six months.
Correct Answer: C 🗳️
Explanation: Only visible for PassCollection members. You can sign-up / login (it's free).
A Snowflake organization MYORG consists of two Snowflake accounts:
The ACCOUNT1 has a database PROD_DB and the ORGADMIN role enabled.
Management wants to have the PROD_DB database replicated to ACCOUNT2.
Are there any necessary configuration steps in ACCOUNT1 before the database replication can be configured and initiated in ACCOUNT2?
- A. It is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.
- B. No configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.
- C. USE ROLE ORGADMIN;
SELECT SYSTEMSGLOBAL ACCOUNT SET_PARAMETER ( 'MYORG. ACCOUNT1', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'TRUE'); USE ROLE ACCOUNTADMIN; ALTER DATABASE PROD_DB ENABLE REPLICATION TO ACCOUNTS MYORG. ACCOUNT2 IGNORE EDITION CHECK; - D. USE ROLE ORGADMIN;
SELECT SYSTEMSGLOBAL_ACCOUNT_SET_PARAMETER ('MYORG. ACCOUNT1', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'TRUE'); SELECT SYSTEMSGLOBAL_ACCOUNT_SET_PARAMETER ('MYORG. ACCOUNT2', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'TRUE'); USE ROLE ACCOUNTADMIN; ALTER DATABASE PROD DB ENABLE REPLICATION TO ACCOUNTS MYORG. ACCOUNT2;
Correct Answer: C 🗳️
Explanation: Only visible for PassCollection members. You can sign-up / login (it's free).
Viewing page 1 out of 16 pages.
Viewing questions 1-5 out of 80 questions.






