Snowflake SnowPro Core Exam Survival Guide

Window: Global | 100 Q / 115 min | Data cloud fundamentals

Must-do topics

• Architecture: cloud services layer, compute (virtual warehouses), storage (micro-partitions), separation of compute & storage
• Data structures: databases/schemas/tables (permanent/transient/temp), stages, file formats, tasks/streams/pipes
• Performance & cost: clustering, caching (result/local), scaling (multi-cluster), pruning
• Security & governance: RBAC, roles (SYSADMIN/SECURITYADMIN), masking, row-access policies, MFA, SSO
• Data sharing & marketplace; zero-copy cloning; time travel & failsafe

Top traps (avoid)

• Thinking warehouses store data; they only compute
• Forgetting Time Travel vs Fail-safe windows & costs
• Misusing transient/temp tables (recovery & costs differ)
• Clustering when not needed; forgetting pruning/caching benefits first
• Granting to users directly instead of roles

Time split

• ~1.1 min/Q; quick first pass on architecture/governance, then performance

Last-48h checklist

• RBAC role hierarchy; best-practice grants (role → role → user)
• Copy into/external stages; file formats; semi-structured data (VARIANT)
• Streams & tasks for CDC; pipes with auto-ingest (Snowpipe)
• Zero-copy clone & Time Travel demos

Quick facts

• Micro-partitions are immutable; metadata drives pruning
• Result cache (24h), local cache (per WH), cloud services cache
• Multi-cluster WH for bursts; auto-suspend/auto-resume saves cost
• Data sharing is reader account capable; no data copy

Speed tactics

• Map requirement → feature (share/clone/time travel/masking)
• Prefer role-based grants and least privilege
• Optimize by pruning & caching before clustering keys

Day-of mini-plan

• Warm-up: 5 RBAC Qs + 3 warehouse/perf Qs
• Watch for wording around governance and zero-copy features
• Keep a steady pace; mark long scenario Qs for a second pass