SnowPro Core (COF-C03) Exam Cheat Sheet

High-yield parking lot revision: Result Cache 24h/31d, Time Travel 0–90d, Fail-safe 7d, XS–6XL credit sizing, and COPY ON_ERROR defaults.

Architecture & Cache Hierarchy

Result cache lasts 24h, resets on reuse up to 31 days max. 0 credits used. Local SSD cache on warehouse nodes. Metadata cache answers COUNT(*) without compute.

Storage & Time Travel Comparison

Permanent tables: 0–90 days TT (Enterprise+) + 7 days Fail-safe (Snowflake support only). Transient & Temporary: 0–1 day TT + 0 days Fail-safe.

Virtual Warehouse Scaling & Pricing

Sizes XS (1) to 6XL (512 credits/hr). Minimum 60-second billing per start/resume. Multi-cluster: STANDARD scales immediately; ECONOMY waits 6 minutes in queue.

Data Loading & Stages

Default COPY ON_ERROR is ABORT_STATEMENT (not SKIP_FILE!). PUT and GET commands run only on internal stages via CLI (not in Snowsight).