Study guide

SnowPro Advanced Architect study guide

Read a lesson, then practice the ideas you want to remember.

Lessons

  1. Multi-Account Strategy & Snowflake Organizat
  2. Database and Schema Design Architecture
  3. Snowflake Parameter Hierarchy & Configuratio
  4. Change Data Capture with Snowflake Streams
  5. Declarative Data Pipelines with Dynamic Tabl
  6. Task Orchestration, DAGs & Serverless Schedu
  7. Views, Materialized Views & Transformation T
  8. Bulk Ingestion Architecture: COPY INTO Optim
  9. Data Unloading Architecture & Cloud Export P
  10. Schema Detection, Schema Evolution & Source-
  11. Snowpipe Continuous Automated Ingestion
  12. Snowpipe Streaming & Real-Time Ingestion
  13. Data Vault 2.0 Architecture in Snowflake
  14. Dimensional Modeling: Star vs. Snowflake Sch
  15. Relational Constraints & Query Optimizer Int
  16. Snowflake Marketplace, Data Exchange & Clean
  17. Direct Data Sharing Architecture & Security
  18. Managed Reader Accounts for External Consume
  19. Aggregation Policies, Projection Policies &
  20. Column-Level Masking & Row Access Policies
  21. Snowflake Editions & Compliance Architecture
  22. Encryption, Key Management & Tri-Secret Secu
  23. Network Policies, Network Rules, External Ac
  24. Object Tagging, Tag-Based Masking & Audit Go
  25. Identity Federation, SSO, SCIM & Authenticat
  26. Role-Based Access Control Architecture & Hie
  27. Secondary Roles, Object Ownership & Delegate
  28. Cloud Storage Integrations & IAM Trust Polic
  29. About the SnowPro Advanced: Architect Exam
  30. Cross-Cloud Auto-Fulfillment & Listing Repli
  31. Database & Account Replication Mechanics
  32. Disaster Recovery Architecture & Client Redi
  33. Data Protection: Time Travel, Fail-safe & St
  34. Three-Tier Caching Architecture & Result Reu
  35. Memory Spilling, Warehouse Queuing & Timeout
  36. Query Profile Deep-Dive & Bottleneck Analysi
  37. Snowflake Ecosystem Connectors, Drivers & SQ
  38. Semi-Structured Data: VARIANT, OBJECT & ARRA
  39. Snowpark, User-Defined Functions & Stored Pr
  40. Warehouse Monitoring, Alerts, Event Tables &
  41. Micro-Partitioning & Automatic Clustering
  42. Resource Monitors, Financial Governance & Us
  43. Search Optimization Service & Point Lookup A
  44. Multi-Cluster Warehouses & Concurrency Scali
  45. Virtual Warehouse Architecture, Sizing & Cre
  46. Warehouse Types & Query Acceleration Service
  47. AI/ML Pipelines & Applications: Cortex AI, M
  48. Data Lakehouse Architecture & Apache Iceberg
  49. DataOps, CI/CD & Snowflake Git Integration
  50. Multi-Tier Environment Strategy & Zero-Copy