Ismail in a yellow bobble hat in front of a snowy mountain, beside a small drawing of Snowflake's three layers

SnowPro Core COF-C03 Study Guide

For Snowflake users who want the certification. New to it? Start with the Field Guide.

The five COF-C03 exam domains, taught from the architecture up.

  • Why the same query can cost zero compute the second time
  • When to scale a warehouse up, and when to scale it out
  • 30 practice questions at the end of each part

65 lessons, 7 practice sets, 4 timed mock exams, 610 questions

Contents

Open any lesson.

Start here2 lessons
  1. Welcome2 min
  2. The COF-C03 Exam, Decoded4 min
Part 1: Architecture6 lessons, 1 set
  1. Why Snowflake Exists7 min
  2. The Three Layers6 min
  3. Micro-partitions9 min
  4. The Three Caches6 min
  5. Snowflake Editions5 min
  6. Exam Focus: Part 11 min
  7. Practice Questions: Part 130 questions
Part 2: Warehouses and performance9 lessons, 1 set
  1. Virtual Warehouses: Compute & Billing12 min
  2. Scaling Warehouses: Up vs Out6 min
  3. Resource Monitors & Budgets6 min
  4. Cost Visibility3 min
  5. Clustering Keys & Automatic Clustering7 min
  6. Search Optimization & Query Acceleration10 min
  7. Materialized Views4 min
  8. Reading the Query Profile9 min
  9. Exam Focus: Part 21 min
  10. Practice Questions: Part 230 questions
Part 3: Access control and security11 lessons, 1 set
  1. The Access Model10 min
  2. System-Defined Roles4 min
  3. Custom Roles & Database Roles6 min
  4. Privileges and GRANT Mechanics9 min
  5. User Management3 min
  6. Authentication Methods7 min
  7. Network Policies6 min
  8. Column-Level Security4 min
  9. Row Access Policies5 min
  10. Secure Views and Governance Odds & Ends6 min
  11. Exam Focus: Part 31 min
  12. Practice Questions: Part 330 questions
Part 4: Data loading and storage11 lessons, 1 set
  1. Stages: Internal vs External8 min
  2. File Formats3 min
  3. Loading Data: COPY INTO <table>8 min
  4. Unloading Data: COPY INTO <location>3 min
  5. Semi-Structured Loading Notes3 min
  6. Snowpipe4 min
  7. Snowpipe Streaming4 min
  8. External Tables3 min
  9. Directory Tables3 min
  10. Loading Best Practices & File Sizing2 min
  11. Exam Focus: Part 41 min
  12. Practice Questions: Part 430 questions
Part 5: Data protection and sharing9 lessons, 1 set
  1. Time Travel4 min
  2. Fail-safe3 min
  3. Zero-Copy Cloning3 min
  4. Database Replication & Failover3 min
  5. Secure Data Sharing Fundamentals3 min
  6. Reader Accounts2 min
  7. Snowflake Marketplace & Listings2 min
  8. Data Exchange1 min
  9. Exam Focus: Part 51 min
  10. Practice Questions: Part 530 questions
Part 6: Database objects and platform12 lessons, 1 set
  1. Databases & Schemas4 min
  2. Table Types4 min
  3. Views: Standard, Secure & Materialized3 min
  4. Dynamic Tables2 min
  5. Streams & Tasks4 min
  6. Stored Procedures2 min
  7. User-Defined Functions2 min
  8. Semi-Structured Data4 min
  9. Apache Iceberg Tables3 min
  10. Performance & Governance Features, Recapped1 min
  11. Sampling, Estimation & Context Functions3 min
  12. Exam Focus: Part 61 min
  13. Practice Questions: Part 630 questions
Part 7: AI features4 lessons, 1 set
  1. Cortex LLM Functions4 min
  2. Cortex Search & Cortex Analyst4 min
  3. AI_EXTRACT, Cortex Code & the ML Functions3 min
  4. Governance, Cost & Exam Focus5 min
  5. Practice Questions: Part 730 questions
Final exam4 mock exams
  1. Mock exam 1: 100 questions100 questions, 115 min
  2. Mock exam 2: 100 questions100 questions, 115 min
  3. Mock exam 3: 100 questions100 questions, 115 min
  4. Mock exam 4: 100 questions100 questions, 115 min
Appendix1 lesson
  1. The Numbers: Final Cheat Sheet4 min

What the exam tests

Five domains, with their official weights, and where this guide covers each one.

Domain 1: Snowflake AI Data Cloud Features & Architecture31%
Part 1, Part 7 for AI features, plus Iceberg and the object model in Part 6
Domain 2: Account Management & Data Governance20%
Part 3, plus resource monitors in Part 2, Time Travel and Fail-safe in Part 5
Domain 3: Data Loading, Unloading & Connectivity18%
Part 4
Domain 4: Performance Optimization, Querying & Transformation21%
Part 2, plus semi-structured data, functions and sampling in Part 6
Domain 5: Data Collaboration10%
Part 5

Course format

Each part ends with 30 practice questions, and the guide ends with four mock exams of 100 questions in 115 minutes. A lesson counts as read once you reach the end of its text or click Next at the bottom, and you can untick it. Sets and mock exams count when you finish them. Progress is saved automatically, and a private link moves it to another device.

Independent study material. Not affiliated with, endorsed by or sponsored by Snowflake Inc. Snowflake and SnowPro are trademarks of Snowflake Inc.