Chapter 1 of 5 · Snowflake SnowPro Core COF-C03

Snowflake AI Data Cloud Features & Architecture

Three layers, editions, tools, object hierarchy, warehouses, storage, table and view types, and AI features.

  • 17topics
  • 1 h 30 minfast track
  • 5diagrams and exhibits
  • 31%of the exam

Topics in this chapter

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

  1. 1Snowflake Architecture - Cloud Services, Compute and Storage LayersLearn the three Snowflake layers for COF-C03: Cloud Services for metadata and optimization, virtual warehouses for compute, and…Diagram5 min
  2. 2Snowflake Editions, Snowsight, Snowflake CLI and IDE IntegrationsCompare Standard, Enterprise, Business Critical and VPS editions, then learn Snowsight, Snowflake CLI and the VS Code extension…5 min
  3. 3Snowflake Object Hierarchy - Organization, Account, Schemas, Tables and ViewsMap the Snowflake object hierarchy from organization and account down to databases, schemas, tables and views, with fully…Diagram6 min
  4. 4Stages, File Formats, Pipes and SequencesKnow user, table, named internal and external stages, named file formats, Snowpipe pipe objects and sequences, with the defaults…5 min
  5. 5UDFs, Stored Procedures, Shares, ML Models and ApplicationsTell UDFs from stored procedures and owner's rights from caller's rights, and see how shares, Model Registry models and Native…6 min
  6. 6Session Context, Variables and Parameter HierarchyUse context functions and session variables, and learn the Snowflake parameter hierarchy and precedence rules (account, user…Diagram5 min
  7. 7Virtual Warehouse Types, Gen 2 and Multi-Cluster Scaling PoliciesConfigure Snowflake virtual warehouses: sizes, Standard Gen 1 and Gen 2, Snowpark-optimized memory, multi-cluster modes and…Diagram5 min
  8. 8Warehouse Configuration by Use Case - Ad-Hoc, Data Loading, BIPick warehouse type, size, Auto-suspend and cluster settings for ad-hoc queries, data loading and BI dashboards, the three use…5 min
  9. 9Warehouse Best Practices - Sizing Up and Down, Scaling In and Out, Auto-SuspendKnow when to size a warehouse up or down, scale clusters out or in, and how to set Auto-suspend against per-second billing and…5 min
  10. 10Warehouse Workloads - Different Teams, High Concurrency, Complex QueriesIsolate teams on separate warehouses, handle high concurrency with multi-cluster scaling and tune complex queries with sizing…5 min
  11. 11Storage Concepts, Micro-partitions and Data ClusteringHow Snowflake stores table data in micro-partitions, how pruning uses their metadata, and when a clustering key and Automatic…Diagram6 min
  12. 12Table Types - Permanent, Temporary and TransientCompare permanent, temporary and transient Snowflake tables by lifetime, visibility, Time Travel retention and Fail-safe, and…5 min
  13. 13Table Types - Apache Iceberg, External and DynamicKnow when to use Apache Iceberg tables, external tables and dynamic tables in Snowflake: storage, catalogs, refresh, target lag…6 min
  14. 14View Types - Standard, Materialized and SecureCompare standard, materialized and secure views in Snowflake: storage, cost, edition, limits, automatic query rewrite and why…5 min
  15. 15AI/ML and App Development, Snowflake Notebooks and Streamlit in SnowflakeMap Snowflake's AI, ML and app features, then learn how Snowflake Notebooks and Streamlit in Snowflake run, who can use them and…5 min
  16. 16Snowpark and Snowflake MLHow Snowpark runs Python, Java and Scala code inside Snowflake, and how Snowflake ML covers features, training, the Model…5 min
  17. 17Snowflake Cortex - AI SQL Functions, Cortex Search and Cortex AnalystSnowflake Cortex for the SnowPro Core exam: AI SQL functions such as AI_COMPLETE, Cortex Search for RAG, Cortex Analyst for text…6 min

About this chapter

What this chapter covers

This chapter is 31% of the SnowPro Core COF-C03 exam, the largest domain by far. It tests whether you understand how Snowflake is built and how to use its core building blocks: the three-layer architecture, editions and tools, the object hierarchy, virtual warehouses, storage and table types, and the AI/ML and app development features.

Questions are single answer or multiple select, usually as short scenarios about "a Snowflake Practitioner". Many hinge on one detail: which layer does the work, which edition a feature needs, which level a parameter wins at, or whether a problem calls for scaling up or out.

How the topics fit together

Every topic in this chapter hangs off the separation of storage, compute and services.

InterfacesSnowsight, CLI, VS Codeconnect toCloud Servicesmetadata, parametersdispatch toVirtual warehousestypes, sizes, clustersreadStoragemicro partitions, tables, viewspowerAI and appsCortex, Snowpark, Streamlit
  • Architecture and editions explain the three layers and which features each edition unlocks.
  • Interfaces and tools cover Snowsight, Snowflake CLI and IDE integrations such as Visual Studio Code.
  • Object hierarchy places every object, from organization and account down to schema-level stages, functions, pipes and models.
  • Session context and parameters decide which settings apply and which level wins.
  • Virtual warehouses cover types (Standard Gen 1 and Gen 2, Snowpark-optimized), scaling policies, use-case configurations and best practices.
  • Storage concepts cover micro-partitions, data clustering, table types (permanent, temporary, transient, Apache Iceberg, external, dynamic) and view types (standard, materialized, secure).
  • AI/ML and app development cover Snowflake Notebooks, Streamlit in Snowflake, Snowpark, Snowflake Cortex (AI SQL functions, Cortex Search, Cortex Analyst) and Snowflake ML.
Exam tip

For warehouse questions, name the bottleneck before reading the options. One heavy query needs a bigger size; many concurrent queries need more clusters; idle time needs a shorter Auto-suspend.

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, tables and examples.
  • Common mistakes: the classic traps.
  • What to remember for the exam: the facts to memorize.
  • Check yourself: three questions to test your understanding.

This chapter rewards exact facts: defaults such as AUTO_SUSPEND 600 seconds, edition boundaries such as Enterprise for multi-cluster warehouses, and precedence rules such as session over user over account. Learn the tables on each page.

Ready for more practice?

The full Snowflake SnowPro Core COF-C03 question bank has 845 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.