SnowPro Advanced Administrator Practice Exam: ADA-C02 Certification Practice Questions

What the SnowPro Advanced Administrator exam tests

The ADA-C02 exam is organized into six domains, and Snowflake publishes the exact weighting in the current study guide dated December 1, 2025. The weights below are the real ones, and they tell you exactly where to spend study time: Security and RBAC alone is nearly a third of the exam. Every domain is tested as an administration decision, not a definition. Here is what each one actually asks.

Because Security and RBAC is nearly a third of the exam, the fastest way to prepare is to drill access-control scenarios until the least-privilege answer is obvious. Generate practice questions from your own Snowflake admin notes across all six domains, and weight your practice toward the security, governance, and performance areas that carry the most points.

Why drill questions for SnowPro Advanced Administrator?

Because the exam rewards administration judgment, and judgment is built by repetition on realistic account scenarios. A question does not ask what a role is; it describes a team that needs read access to one schema and write access to another, plus a service account, and asks for the grant structure that gives exactly that and nothing more. You can administer Snowflake every day and still miss these if your account only ever used a couple of roles. Practice questions that force the access decision are the fastest way to widen that range before you sit a US$375 exam.

Uploading your notes and generating questions from them is cheap insurance on an exam that costs US$375 per attempt and expects real administration experience. It forces you across all six domains and the scenario style, rather than practicing only the part of Snowflake your current account happens to use.

SnowPro Advanced Administrator exam questions, answered

Is the exam code ADA-C01 or ADA-C02?

ADA-C02 is current. Snowflake launched it on January 19, 2026 and retired the older ADA-C01 around the same transition. This is more than a normal code bump: the domain weightings were reorganized. Plenty of older prep and dumps still say ADA-C01, so treat any ADA-C01 material as out of date and check that your notes map to the current ADA-C02 domains and weights before you trust them.

Do I need SnowPro Core before the Advanced Administrator exam?

Yes. You must hold an active SnowPro Core certification in good standing to earn ADA-C02, and it cannot be expired. Snowflake also recommends about two years of hands-on Snowflake administration experience, but only the active Core credential is a hard requirement. If you are still working toward Core, note that the current Core exam is COF-C03, released February 16, 2026.

How many questions are on the ADA-C02 exam?

65 questions in 115 minutes, mixing multiple choice and multiple select in scenario form. That is a little under two minutes per question. Because the questions describe an administration situation and ask for the best action rather than a single fact, most people use most of the window, so practice reading a scenario and eliminating the weaker answers quickly.

What is the passing score for SnowPro Advanced Administrator?

750 on a scaled score from 0 to 1000. Snowflake uses scaled scoring, so 750 does not translate to a fixed number of questions correct; harder questions carry more weight. Aim to pass practice sets comfortably rather than targeting the exact threshold, because the scaling means a couple of hard misses can cost more than you expect.

What is the difference between Administrator and Architect?

Administrator (ADA-C02) is about operating and securing an existing account: RBAC and user administration, account management and governance, performance monitoring, and recovery. Architect (ARA-C01) is about designing the platform: multi-cluster structure, replication topology, and continuity. Choose Administrator if you run and secure the account daily, Architect if you design the environment. Both require active SnowPro Core first.

How much does the certification cost?

US$375 per attempt for ADA-C02, on top of the SnowPro Core exam you must already hold, which is US$175. So the full path is US$550 before any retakes. A retake fee applies for a second attempt; confirm the current amount on Snowflake's certification page when you register. Given the cost per attempt, it pays to drill until you are consistently passing practice sets first.

Is the SnowPro Advanced Administrator worth it?

For someone who administers Snowflake accounts, yes. It signals that you can secure, govern, monitor, and recover a Snowflake environment, not just query it, and it carries real weight in hiring for platform and database administration roles. If you are still learning fundamentals, start with SnowPro Core and return to Administrator once you manage real accounts.

PDFQuiz is not affiliated with, endorsed by, or sponsored by Snowflake. Snowflake and SnowPro are trademarks of Snowflake Inc. This generator builds practice questions from material you upload and is a study aid, not a substitute for the official exam guide or training. Exam details change, so always confirm current details on Snowflake's certification page before you book.