Snowflake recommends two or more years of hands-on architect experience before you sit the SnowPro Advanced: Architect exam, and that recommendation tells you what kind of test it is. It leans on design judgment, not syntax recall. What surprises people on the day is the exam mechanics: not knowing how the exam is built, which domains carry the weight, and how tight the clock actually is.
Here’s what the ARA-C01 exam is like, with the exam facts taken from Snowflake’s certification pages and official exam guide.
How Many Questions, and How Long
The exam is 65 questions in 115 minutes, in three formats: multiple-choice, multiple-select, and true/false.
That works out to about 1.8 minutes per question. It sounds comfortable, and for the true/false and straightforward items it is. The trap is the scenario questions: a multi-paragraph setup describing an account layout or a data-sharing requirement, where reading and reasoning eats three or four minutes before you even look at the options. Bank time on the quick ones so you can spend it on those.
The Four Domains, and Where the Questions Concentrate
This is the single most useful thing to know before you study. The exam is weighted, and one domain is nearly a third of it.
| Domain | Weight |
|---|---|
| Snowflake Architecture | 30% |
| Accounts and Security | 25% |
| Data Engineering | 25% |
| Performance Optimization | 20% |
Snowflake Architecture is the heaviest at 30%: multi-cluster shared data architecture, the storage, compute, and cloud-services layers, and designing end-to-end data flows. If your day job leans toward pipelines or tuning, this is the domain most likely to surprise you, because it rewards the systems-design view rather than the operator view.
Accounts and Security and Data Engineering are tied at 25% each. Security covers account structures, RBAC, network policies, and encryption for enterprise deployments. Data Engineering covers ELT design, data sharing, and Snowflake Marketplace. Performance Optimization is the lightest at 20%: warehouse sizing, clustering, materialized views, query profiling, and resource monitors.
The practical read: Architecture alone is nearly a third, and pairing it with either 25% domain covers 55% of the exam. If you’re short on prep time, protect Architecture first.
What “Advanced” Actually Means for This Exam
There is no formal prerequisite listed for ARA-C01. What Snowflake recommends instead is two or more years of hands-on experience with Snowflake as an architect in a production environment. That experience bar is the clearest signal of what to expect: the questions favor picking the best design for a stated set of business, security, and compliance requirements over recalling a single correct fact. Study for judgment calls, not definitions.
What You Need to Pass
The passing score is 750 out of 1000. That’s a scaled score, not a percentage, so it does not mean “get 75% of the questions right.” Snowflake weights the score, so you can’t reverse-engineer how many questions you needed from the number. Treat 750 as the bar and stop trying to do the arithmetic.
If You Don’t Pass the First Time
The retake rules are fixed, and worth knowing before you book so a fail doesn’t strand you:
- After a failed attempt, you wait seven days before you can retake.
- You’re allowed four retakes of a given exam in any 12-month period.
- Every attempt is the full exam fee. There are no free retakes or discounts.
Your score report shows how you did per domain. Before rebooking, put your time into the domain where you scored lowest and, where they overlap, the domains that carry the most weight.
Keeping the Certification
SnowPro certifications expire two years after they’re awarded. You renew through the Continuing Education program, either by earning an equivalent or higher certification or by completing one Snowflake Instructor-Led Training course. It has to be done before your expiration date to count. You can also retake the full exam starting six months before you expire if you’d rather recertify that way.
Before You Book
Reading about the format only gets you so far. Two things are worth doing before you book: get your scores steady across all four domains, and put in enough scenario practice that the “best fit” answers come quickly under the clock.
SnowPro Advanced: Architect practice questions in Pass-IT are organized around the four exam domains above, with per-domain tracking that shows exactly where your gaps are, so you can see whether Architecture or Security is the one holding you back before you sit the real thing. Free to start, no card for your first session.