Snowflake SnowPro Advanced: Architect (ARA-C01) Lessons
13 lessons, one per exam-guide subdomain, in the order the guide teaches them. Every claim is cited to the official documentation.
Domain 1: Account and Security
3 lessons · 25% of the exam
1.1Snowflake Account Strategy: Organizations, Isolation and Multi-Account Design
Subdomain 1.1: Design a Snowflake account and database strategy, based on business requirements.
2 pages · 22 min read
1.2Snowflake RBAC Design: Role Hierarchy, System, Database and Secondary Roles
Subdomain 1.2: Design an architecture that meets data security, privacy, compliance, and governance requirements.
2 pages · 25 min read
1.3Snowflake Encryption, Network Policies, Network Rules and Private Connectivity
Subdomain 1.3: Outline Snowflake security principles and identify use cases where they should be applied.
2 pages · 20 min read
Domain 2: Snowflake Architecture
5 lessons · 30% of the exam
2.1Snowflake Data Models: Star Schema, Data Vault and Declared Keys
Subdomain 2.1: Outline the benefits and limitations of various data models in a Snowflake environment.
2 pages · 19 min read
2.2Snowflake Secure Data Sharing: Shares, Privileges and Security Patterns
Subdomain 2.2: Design data sharing solutions, based on different use cases.
2 pages · 28 min read
2.3Snowflake Dev Environments, CI/CD Pipelines and Rollback
Subdomain 2.3: Create architecture solutions that support development lifecycles as well as workload requirements.
2 pages · 21 min read
2.4Snowflake Object Hierarchy: Containers, Roles, Views and Warehouses
Subdomain 2.4: Given a scenario, outline how objects exist within the Snowflake object hierarchy and how the hierarchy impacts an architecture.
2 pages · 19 min read
2.5Time Travel, Fail-safe and Table Types for Snowflake Data Recovery
Subdomain 2.5: Determine the appropriate data recovery solution in Snowflake and how data can be restored.
2 pages · 22 min read
Domain 3: Data Engineering
3 lessons · 25% of the exam
3.1Choosing a Snowflake Ingestion Path: Bulk COPY, Snowpipe, Snowpipe Streaming, External and Iceberg Tables
Subdomain 3.1: Determine the appropriate data loading or data unloading solution to meet business needs.
2 pages · 22 min read
3.2Snowflake Connectors: Kafka, Spark, Python and ServiceNow
Subdomain 3.2: Outline key tools in Snowflake’s ecosystem and how they interact with Snowflake.
2 pages · 22 min read
3.3Snowflake Views, Dynamic Tables, Streams and Tasks
Subdomain 3.3: Determine the appropriate data transformation solution to meet business needs.
2 pages · 23 min read
Domain 4: Performance Optimization
2 lessons · 20% of the exam
4.1Snowflake Warehouse Performance Tuning: Query Profile, Spilling, Queuing, QAS and Snowpark-Optimized Warehouses
Subdomain 4.1: Outline performance tools, best practices, and appropriate scenarios where they should be applied.
2 pages · 29 min read
4.2Micro-partition Pruning and Clustering Information for Slow Queries
Subdomain 4.2: Troubleshoot performance issues with existing architectures.
2 pages · 29 min read