ARA-C01
SnowPro Advanced: Architect ARA-C01 practice exams
290 questions in 5 timed practice tests. Each test has about 60 questions and a 105-minute limit. The pass mark is 75%. Results are split across the 4 exam domains.
Exam at a glance
| Practice tests | 5 |
|---|---|
| Questions in total | 290 |
| Questions per test | About 60 |
| Time limit per test | 105 minutes |
| Pass mark | 75% |
| Question types | Single answer and multiple answer (32 multiple-answer questions) |
| Level | Professional |
| Category | Data & Analytics |
These are the settings of our practice tests. Check the official Snowflake exam page for the current exam format before you book.
Domains and weights
| Domain | Weight | Weight bar | Questions in our bank |
|---|---|---|---|
| Accounts and Security | 28% | 81 | |
| Snowflake Architecture | 27% | 78 | |
| Data Engineering | 23% | 67 | |
| Performance Optimization | 22% | 64 |
Sample questions
Question 1 of 3
A service account used by an ETL tool must authenticate without a password and without interactive MFA prompts, and the security team wants to rotate credentials with no downtime. Which approach should the architect recommend?
- A Password authentication with a password policy requiring rotation every 30 days and a minimum length of 14 characters
- B SAML single sign-on through the corporate IdP with an exception that skips MFA for the ETL service account
- C Key-pair authentication, setting RSA_PUBLIC_KEY_2 to the new key before removing the old RSA_PUBLIC_KEY value (correct answer)
- D Snowflake OAuth with a refresh token validity set to the maximum so that tokens rarely need to be reissued
Question 2 of 3
A data platform team wants to grant SELECT on every table that will ever be created in the SALES.RAW schema to the ANALYST role, but table owners must not be able to grant access to their tables themselves. Which design meets both requirements?
- A Define future grants at the database level on SALES and grant MANAGE GRANTS to the role that loads data into RAW
- B Keep SALES.RAW as a regular schema and have each object owner run GRANT SELECT after creating a new table
- C Grant OWNERSHIP of the SALES.RAW schema to ANALYST so that the role automatically sees every table created in it
- D Create SALES.RAW as a managed access schema and define future grants of SELECT on tables in that schema to ANALYST (correct answer)
Question 3 of 3
A company wants all connections from its corporate offices to be allowed while all other client IP addresses are blocked, and it wants to manage the address list as a reusable schema-level object that several policies can reference. Which approach should be used?
- A Create a session policy with a short idle timeout and attach it to the account so that unknown clients are disconnected
- B Create a security integration of type SAML2 so that only users federated through the corporate IdP can sign in
- C Create network rules for the office CIDR ranges and list them in a network policy's ALLOWED_NETWORK_RULE_LIST (correct answer)
- D Create an authentication policy that restricts CLIENT_TYPES to Snowflake UI and drivers used on the corporate network
See all 10 free ARA-C01 questions with answers Read them or quiz yourself.
What your score report looks like
Example attempt, ARA-C01 practice test 3
77%
Passed
Pass mark 75%
| Domain | Weight | Your score | % |
|---|---|---|---|
| Accounts and Security | 28% | 88 | |
| Snowflake Architecture | 27% | 81 | |
| Data Engineering | 23% | 76 | |
| Performance Optimization | 22% | 58 |
Study next: Performance Optimization. It is below the pass mark and carries 22% of the exam.
Study plans
Two weeks
- Day 1: take practice test 1 in exam mode to get a baseline.
- Days 2 to 5: domain mode on Accounts and Security and Snowflake Architecture, the two most heavily weighted domains.
- Day 6: practice test 2 in exam mode, then the mistakes quiz.
- Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
- Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.
Four weeks
- Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
- Week 2: domain mode on those two domains, then a second practice test in exam mode.
- Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
- Week 4: practice test 5 and final mode until your readiness holds above the pass mark.
Questions about the ARA-C01 practice exams
- Are these real ARA-C01 exam questions?
- No. We write every question ourselves and map it to the published ARA-C01 exam objectives. We do not use leaked or recalled questions.
- Do the time limit and pass mark match the official exam?
- They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
- Can I try it before I pay?
- Yes. The free mini exam has 15 questions with full explanations and needs no account.
- How long do I keep access?
- A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
- What happens after I finish a test?
- You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.
Related exams
| Exam | Vendor | Level | Questions | Minutes | Price |
|---|---|---|---|---|---|
| COF-C03SnowPro Core COF-C03 | Snowflake | Associate | 300 | 70 | $12.99 |
| DEA-C02SnowPro Advanced: Data Engineer (DEA-C02) | Snowflake | Professional | 300 | 115 | $14.99 |
| DP-900Azure Data Fundamentals DP-900 | Microsoft | Foundational | 225 | 45 | $9.99 |
| SPLK-1001Splunk Core Certified User (SPLK-1001) | Splunk | Foundational | 300 | 60 | $9.99 |
| 1Z0-071Oracle Database SQL 1Z0-071 | Oracle | Associate | 315 | 120 | $12.99 |
| 1Z0-082Oracle Database Admin I 1Z0-082 | Oracle | Associate | 300 | 100 | $12.99 |