Data & Analytics

Snowflake SnowPro Core (COF-C02)

Complete, exam-focused prep for the Snowflake SnowPro Core Certification (COF-C02). Covers all six domains: Snowflake architecture and features (the three-layer design, separation of storage and compute, virtual warehouses and scaling up vs out, micro-partitions, clustering keys, semi-structured VARIANT data, and editions); account access and security (role-based access control and the system-role hierarchy, MFA, key pair and federated authentication, network policies, end-to-end encryption, dynamic data masking and row access policies); performance concepts (the result, metadata and warehouse caches, the Query Profile, search optimization, materialized views, and warehouse sizing); data loading and unloading (stages, COPY INTO and load metadata, Snowpipe continuous loading, file formats, and unloading); data transformations (SQL and semi-structured queries with FLATTEN, secure views, streams and tasks for ELT, UDFs, stored procedures, and Snowpark); and data protection and sharing (Time Travel and Fail-safe, zero-copy cloning, and Secure Data Sharing with reader accounts and the Marketplace). Includes exam-trap callouts, per-domain mastery checks, a 50-question mock, a full-length 125-question exam simulator, and a spaced-repetition flashcard deck. SnowPro Core is about 100 questions in 115 minutes with a 750 scaled passing score.

7domains / modules
30lessons
329practice questions
34flashcards

0.00 USD

Start this course →

What you'll study

Domain 1 — Snowflake Architecture & Features (24%)

Domain 2 — Account Access & Security (18%)

Domain 3 — Performance Concepts (12%)

Domain 4 — Data Loading & Unloading (10%)

Domain 5 — Data Transformations (18%)

Domain 6 — Data Protection & Data Sharing (18%)

Quick Reference — Exam-Day Cheat-Sheet

Practice and exam readiness

Related courses

Create a free account to preview lessons. Browse all courses.