Chapter 2 of 4 · Snowflake ARA-C01

Snowflake Architecture

Data models, data sharing, data lakes and environments, workloads and the development lifecycle.

  • 18topics
  • 1 h 32 minfast track
  • 6diagrams and exhibits
  • 30%of the exam

Topics in this chapter

Take them in order, or jump to the one you need.

  1. 1Data Models, Data Vault, Star Schema and ConstraintsCompare star schema, snowflake schema, 3NF and Data Vault on Snowflake and learn how ENABLE, VALIDATE and RELY constraint…5 min
  2. 2Designing Data Sharing - Use Cases, Same Account, Same Region and Cross RegionDesign Secure Data Sharing by use case: same account, same organization, same region, cross region and cross cloud, and between…Diagram6 min
  3. 3Sharing to Non-Snowflake Customers and Cross-Cloud Auto-FulfillmentShare data with customers who have no Snowflake account using reader accounts, and reach other clouds and regions with…Diagram5 min
  4. 4Data Clean Rooms, Snowflake Marketplace and Data ExchangeChoose between Snowflake Data Clean Rooms, the public Marketplace and a private Data Exchange, and know the roles, listing types…5 min
  5. 5Data Sharing Methods, Share Configuration, Privileges and Security PatternsCompare direct shares, listings and replication, configure shares and privileges, and apply secure view, database role and…5 min
  6. 6Data Lake Layout, Warehouse Zones, DataOps and EnvironmentsDesign data lake storage paths, warehouse zones, DevOps and DataOps practices and separate production, development and sandbox…5 min
  7. 7Data Workloads, Data Warehouse Design and ELT versus ETLMatch Snowflake workloads to compute: separate warehouses, multi-cluster, Snowpark-optimized and query acceleration, and choose…4 min
  8. 8Development Lifecycle - Migration, Deployment, CI/CD and Snowflake CLIPlan migrations to Snowflake and automate deployment with CI/CD pipelines, versioned or declarative scripts and the Snowflake…Diagram5 min
  9. 9Git Integration and Rollback Processes in SnowflakeConnect Git repositories to Snowflake with CREATE GIT REPOSITORY and plan rollback using Time Travel, UNDROP, clones, swap and…5 min
  10. 10AI/ML Pipelines, Snowflake ML Functions and Cortex LLM FunctionsDesign a basic AI/ML pipeline on Snowflake and choose between Snowflake ML functions, Cortex LLM functions, Snowpark and…5 min
  11. 11Snowpark Container Services, Streamlit in Snowflake and Native AppsChoose between Snowpark Container Services, Streamlit in Snowflake and the Snowflake Native App Framework to run custom code…6 min
  12. 12Object Hierarchy - Account Level Objects, Roles and WarehousesHow Snowflake objects nest from organization to schema, and why roles and virtual warehouses sit at account level and shape…6 min
  13. 13Object Hierarchy - Databases, Schemas, Tables and ViewsDatabases, schemas, table types and view types as design choices: transient and temporary tables, secure and materialized views…5 min
  14. 14Object Hierarchy - Stages, File Formats, Functions, Procedures, Streams and TasksPlace stages, file formats, UDFs, stored procedures, streams and tasks: stage types, format precedence, owner's rights and stream…5 min
  15. 15Data Recovery Solutions - Backup, Recovery and Data Corruption ImpactsPick the right Snowflake recovery layer: Time Travel, cloning, backup sets, Fail-safe or replication, and see how data corruption…5 min
  16. 16Time Travel - Table Types, Costs, Availability and Query PerformanceTime Travel for architects: retention by edition and table type, AT and BEFORE clauses, UNDROP, storage cost and the effect of…Diagram5 min
  17. 17Zero-Copy Cloning and Fail-safeHow zero-copy cloning works, what a clone copies and skips, how it combines with Time Travel, and what Fail-safe offers, costs…Diagram5 min
  18. 18Disaster Recovery - Replication, Failover Groups and Business ContinuityDesign Snowflake disaster recovery with replication and failover groups, refresh schedules, promotion and failback, plus edition…Diagram5 min

About this chapter

What this chapter covers

Snowflake Architecture is the chapter on how an architect shapes data, shares it and delivers changes. For the SnowPro Advanced: Architect ARA-C01 exam it tests design decisions rather than definitions: which model, which sharing method, which environment layout, and why.

Questions are scenarios that start with "An Architect needs to ...". They are single answer, multiple select or interactive, and the right answer usually turns on one trade-off such as region, cost owner, isolation or a default value.

How the topics fit together

Data is modeled, shared with others, laid out in zones and environments, processed by workloads and moved to production through a controlled lifecycle.

Data modelsstar, vault, constraintsshared viaSharingshares, listings, clean roomsorganized inZones and environmentsraw to consumptionrun byWorkloadswarehouses, ELTreleased byLifecycleCI/CD, Git, rollback
  • Data models and constraints cover star schema, Data Vault and which constraints Snowflake enforces.
  • Data sharing covers same account, same region, cross region, reader accounts, Cross-Cloud Auto-Fulfillment, clean rooms, Marketplace and Data Exchange.
  • Sharing configuration covers grants, secure views, REFERENCE_USAGE and SHARE_RESTRICTIONS.
  • Lake, zones and environments cover storage paths, layers, DataOps, cloning and account separation.
  • Workloads cover warehouse design and ELT versus ETL.
  • Lifecycle covers migration, deployment, Snowflake CLI, Git integration and rollback.
Exam tip

Learn the "who pays and where" rules. Providers pay for shared storage and reader account compute, consumers pay only for their own queries, and direct shares stop at region and cloud boundaries.

How to use these pages

Each topic page has the same shape, so you can skim for what you need.

  • What it is: the idea in plain words.
  • How it works: the mechanism, with diagrams, SQL and comparison tables.
  • Common mistakes: the classic traps.
  • What to remember for the exam: the facts to memorize.
  • Check yourself: three questions to test your understanding.

Ready for more practice?

The full Snowflake ARA-C01 question bank has 687 questions, with timed practice exams and an explanation for every answer.

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.