SnowPro Core Prep

Alpine Retail · You are Priya Chen · COF-C03 · Labs 00–19

Pass SnowPro Core.
One plain-English lab at a time.

Not random flashcards. A full workshop that covers every COF-C03 domain — architecture, security, loading, performance, collaboration — with comics, tiny SQL, and exam drills.

1. Read the Alpine story 2. Start Lab 00

Required context (read before Lab 00)

The situation

Alpine Retail hired Priya Chen (that’s you). Manager Morgan Hale wants Snowflake live and your SnowPro Core badge within weeks. Coach Dev Okonkwo teaches you like you’re smart but new — no jargon wall.

  • Kai Rivera — Analyst (asks the questions you’re too shy to ask)
  • Riley Okada — Data Engineer peer (loading & pipelines)
  • Sam Park — Compliance (governance & security)

Database you will build: ALPINE_RETAIL. Full cast: Story.

Exam at a glance (COF-C03)
DomainWeightLabs
Architecture31%01–05
Account & governance20%06–09
Loading & connectivity18%10–12
Performance & SQL21%13–15
Collaboration10%16–18
Mock exam—19

Checklist: EXAM_BLUEPRINT.md · Schedule: COURSE_SCHEDULE.md

How this course teaches Every lab: problem → BEFORE/AFTER → comics (Kai asks, Dev explains why) → tiny SQL → Exam presses further → Priya wrap-up. If a step feels hard: read the comic above it before the SQL. Teaching standard · Snowsight gotchas.

Labs

00

Build the workshop

Problem: no Snowflake home. → ALPINE_RETAIL.

 01

Three layers + editions

Architecture heart of the exam.

 02

Object catalog

Tables, views, stages, pipes, shares…

 03

Micro-partitions

Clustering & storage monitoring.

 04

Table types

Perm / transient / Iceberg / Dynamic.

 05

Interfaces + AI

Snowsight, Snowpark, Cortex, Streamlit.

 06

RBAC badges

Roles, grants, ownership.

 07

Auth & network

MFA, SSO, key-pair, Trust Center.

 08

Governance policies

Masking, RAP, tags, lineage.

 09

Credits & monitors

FinOps + ACCOUNT_USAGE.

 10

Stages & COPY

Load, unload, file formats.

 11

Snowpipe

Auto-ingest + Streaming story.

 12

Streams & tasks

Plus Dynamic Tables.

 13

Query Profile

Caches, pruning, QAS.

 14

Warehouse scaling

Size vs scale-out vs MCW.

 15

SQL + VARIANT

QUALIFY, MERGE, FLATTEN.

 16

Time Travel

UNDROP, Fail-safe windows.

 17

Clone & replicate

Zero-copy + DR vocabulary.

 18

Share & Marketplace

Reader accounts, Clean Rooms.

 19

Mock exam

Timed domain drills — book only after this.