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

ARA-C01 practice exam settings
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

ARA-C01 exam domains, weights and question counts
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?

  1. A Password authentication with a password policy requiring rotation every 30 days and a minimum length of 14 characters
  2. B SAML single sign-on through the corporate IdP with an exception that skips MFA for the ETL service account
  3. C Key-pair authentication, setting RSA_PUBLIC_KEY_2 to the new key before removing the old RSA_PUBLIC_KEY value (correct answer)
  4. D Snowflake OAuth with a refresh token validity set to the maximum so that tokens rarely need to be reissued
Why: Key-pair authentication is designed for programmatic clients; Snowflake supports two public key slots per user, so a new key can be registered in RSA_PUBLIC_KEY_2, clients switched over, and the old key removed with no downtime. Passwords for service users are discouraged and rotating them forces coordinated cut-overs. SAML SSO requires a browser-based flow unsuitable for unattended ETL. Long-lived OAuth refresh tokens still require an initial interactive consent and extending them weakens security rather than enabling clean rotation.

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?

  1. A Define future grants at the database level on SALES and grant MANAGE GRANTS to the role that loads data into RAW
  2. B Keep SALES.RAW as a regular schema and have each object owner run GRANT SELECT after creating a new table
  3. C Grant OWNERSHIP of the SALES.RAW schema to ANALYST so that the role automatically sees every table created in it
  4. D Create SALES.RAW as a managed access schema and define future grants of SELECT on tables in that schema to ANALYST (correct answer)
Why: In a managed access schema only the schema owner or a role with MANAGE GRANTS can grant privileges on contained objects, so table owners lose discretionary grant control, and future grants automatically give ANALYST SELECT on new tables. Leaving the schema regular lets object owners grant access themselves, which violates the requirement. Giving ANALYST ownership of the schema grants far more than read access. Granting MANAGE GRANTS to the loading role gives it account-wide grant power, the opposite of what is needed.

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?

  1. A Create a session policy with a short idle timeout and attach it to the account so that unknown clients are disconnected
  2. B Create a security integration of type SAML2 so that only users federated through the corporate IdP can sign in
  3. C Create network rules for the office CIDR ranges and list them in a network policy's ALLOWED_NETWORK_RULE_LIST (correct answer)
  4. D Create an authentication policy that restricts CLIENT_TYPES to Snowflake UI and drivers used on the corporate network
Why: Network rules are schema-level objects that group IP ranges (or other identifiers) and can be referenced by one or more network policies through ALLOWED_NETWORK_RULE_LIST, which is the current recommended way to restrict client IPs. A session policy controls idle session timeouts, not source addresses. Authentication policies control authentication methods and client types, not IP ranges. A SAML integration controls who can authenticate but does not block traffic from outside the corporate network.

What your score report looks like

Example attempt, ARA-C01 practice test 3

77%

Passed
Pass mark 75%

Score by exam domain
DomainWeightYour 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.

Domains and pass mark from our ARA-C01 practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Accounts and Security and Snowflake Architecture, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. 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.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Snowflake. ARA-C01 and related names are trademarks of their owners.

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