Study guide
SnowPro Advanced Architect study guide
Read a lesson, then practice the ideas you want to remember.
Lessons
- Multi-Account Strategy & Snowflake Organizat
- Database and Schema Design Architecture
- Snowflake Parameter Hierarchy & Configuratio
- Change Data Capture with Snowflake Streams
- Declarative Data Pipelines with Dynamic Tabl
- Task Orchestration, DAGs & Serverless Schedu
- Views, Materialized Views & Transformation T
- Bulk Ingestion Architecture: COPY INTO Optim
- Data Unloading Architecture & Cloud Export P
- Schema Detection, Schema Evolution & Source-
- Snowpipe Continuous Automated Ingestion
- Snowpipe Streaming & Real-Time Ingestion
- Data Vault 2.0 Architecture in Snowflake
- Dimensional Modeling: Star vs. Snowflake Sch
- Relational Constraints & Query Optimizer Int
- Snowflake Marketplace, Data Exchange & Clean
- Direct Data Sharing Architecture & Security
- Managed Reader Accounts for External Consume
- Aggregation Policies, Projection Policies &
- Column-Level Masking & Row Access Policies
- Snowflake Editions & Compliance Architecture
- Encryption, Key Management & Tri-Secret Secu
- Network Policies, Network Rules, External Ac
- Object Tagging, Tag-Based Masking & Audit Go
- Identity Federation, SSO, SCIM & Authenticat
- Role-Based Access Control Architecture & Hie
- Secondary Roles, Object Ownership & Delegate
- Cloud Storage Integrations & IAM Trust Polic
- About the SnowPro Advanced: Architect Exam
- Cross-Cloud Auto-Fulfillment & Listing Repli
- Database & Account Replication Mechanics
- Disaster Recovery Architecture & Client Redi
- Data Protection: Time Travel, Fail-safe & St
- Three-Tier Caching Architecture & Result Reu
- Memory Spilling, Warehouse Queuing & Timeout
- Query Profile Deep-Dive & Bottleneck Analysi
- Snowflake Ecosystem Connectors, Drivers & SQ
- Semi-Structured Data: VARIANT, OBJECT & ARRA
- Snowpark, User-Defined Functions & Stored Pr
- Warehouse Monitoring, Alerts, Event Tables &
- Micro-Partitioning & Automatic Clustering
- Resource Monitors, Financial Governance & Us
- Search Optimization Service & Point Lookup A
- Multi-Cluster Warehouses & Concurrency Scali
- Virtual Warehouse Architecture, Sizing & Cre
- Warehouse Types & Query Acceleration Service
- AI/ML Pipelines & Applications: Cortex AI, M
- Data Lakehouse Architecture & Apache Iceberg
- DataOps, CI/CD & Snowflake Git Integration
- Multi-Tier Environment Strategy & Zero-Copy