Exam at a glance
- Exam name: SnowPro® Core Certification (COF-C02)
- Questions: 100 total
- Time limit: 115 minutes
- Question types: multiple-choice, multiple-select, and interactive items
- Delivery: online proctoring or onsite testing centers
- Passing score: 750 (scaled scoring 0–1000)
Tip: Expect scenario-style questions that reward knowing Snowflake “defaults” (RBAC, loading patterns, warehouse sizing, time travel/clone behaviors).
Domain breakdown (weights)
- Domain 1: Snowflake AI Data Cloud Features & Architecture (24%)
- Domain 2: Account Access and Security (18%)
- Domain 3: Performance and Cost Optimization Concepts (16%)
- Domain 4: Data Loading and Unloading (12%)
- Domain 5: Data Transformations (18%)
- Domain 6: Data Protection and Data Sharing (12%)
Who should take COF-C02
- Data analysts, data engineers, and platform users who work in Snowflake day-to-day
- Teams adopting Snowflake and wanting a validated baseline across loading, security, and core SQL workflows
- Practitioners who can navigate Snowflake UI/SQL and reason about cost/performance trade-offs
Recommended background: Hands-on familiarity with virtual warehouses, databases/schemas/roles, loading data with stages + COPY INTO, and core features like Time Travel, cloning, and data sharing.
Study plan (efficient)
- Skim the domains & weights to prioritize high-yield areas.
- Work the Syllabus domain-by-domain; drill questions immediately after each domain.
- Keep a miss log: turn misses into compact “rules of thumb” and revisit within 24–48 hours.
- Mixed mocks + review: practice under time, then review every miss and re-drill weak domains.
Ready to drill by domain? Start in the Syllabus.