SnowPro Core Certification
Snowflake · SnowPro Certification Prep
Theory
SnowPro Core is the foundation certification and the prerequisite for the SnowPro Advanced exams. The current version, COF-C03, replaced COF-C02 in 2026. It checks broad knowledge of the platform rather than depth in one area: the AI Data Cloud architecture, managing accounts and virtual warehouses, loading, unloading and transforming data, structured, semi-structured and unstructured data, monitoring and optimising performance, data collaboration and protection, and connectivity.
Question count, duration, fee and domain weights are published in the official study guide and change between versions, so read it before booking. A good test of readiness is explaining, without notes, why compute and storage scale separately and what each cache layer does.
Why we use it
The Core exam gives a structured syllabus for learning Snowflake end to end and a recognised proof of skill for employers and clients. It is also the gate to all role-based advanced exams.
When to use it
Take it after hands-on practice with every major area, not just reading. If you work daily with only one part of Snowflake, such as BI queries, plan extra study on loading, security and data protection.
Exam Format & Domains
COF-C03 reorganised the syllabus and adds newer areas such as AI features, unstructured data and connectivity. Snowflake's official COF-C03 study guide lists the exact domains, weights, question count, time and fee — use it rather than older COF-C02 blog posts.
Highest-Value Topics to Study
The three-layer architecture, virtual warehouse sizing and scaling, micro-partitions and clustering, Time Travel/Fail-safe/Zero-Copy Cloning, RBAC and system-defined roles, COPY INTO with stages and file formats, the three caching layers, and semi-structured data with VARIANT/FLATTEN.
How to Prepare
Combine the free trial's hands-on practice with Snowflake's official documentation — this exam rewards breadth across the whole platform over depth in any one area, so skipping a whole domain (like data sharing) is a common way to fail on borderline scores.
How it works
- Download the current official study guide
- Map each domain to topics in this course
- Practise every feature in a trial account
- Can you explain each topic without notes? Yes: Take practice questions and review mistakes. No: Revisit that topic hands-on.
- Book the exam
Example
-- Quick self-check before booking the exam:
-- Can you explain, without notes, why compute and storage scale independently?
-- Can you name all 3 cache layers and what each one skips?
-- Do you know the default Time Travel retention vs the Enterprise max?Key points
- Current version is COF-C03; it replaced COF-C02
- Prerequisite for the SnowPro Advanced certifications
- Rewards broad platform coverage over narrow depth
- Know the three layers, cache types and Time Travel vs Fail-safe well
- Hands-on practice beats memorising feature lists