SnowPro Core Exam: Complete Guide to Scope, Sample Questions & Strategy

SnowPro Core Certification (COF-C03) is the foundational official Snowflake certification. The exam consists of 100 questions in 115 minutes with a passing score of 750/1000, broadly covering Snowflake's core features. This article breaks down the weighting of every exam domain, the key topics in each one, and a concrete study strategy.

Exam Overview

Exam Domains and Weighting

COF-C03 is organized into 6 domains. Architecture (25%) and Account Access & Security (20%) together account for 45% of the exam, so mastering these two areas largely determines whether you pass.

Study Focus for Each Domain

Domain 1: Architecture (25%)

This is the highest-weighted domain on the exam. You need to be able to clearly distinguish the roles of each layer in the 3-layer architecture (Storage / Compute / Cloud Services). Questions asking "which layer handles this operation" come up frequently.

• Micro-partition characteristics (50-500 MB, columnar, immutable, automatically managed)
• The three cache types (Result Cache / Metadata Cache / Warehouse Cache): where each is stored and what invalidates them
• Feature differences across Standard / Enterprise / Business Critical / VPS editions
• The difference between Data Marketplace and Data Exchange

Domain 2: Account Access & Security (20%)

The most important topics are the role-based access control (RBAC) hierarchy and the privilege scope of the default roles (ACCOUNTADMIN / SECURITYADMIN / SYSADMIN / USERADMIN / PUBLIC).

• Role hierarchy and how GRANT statements behave
• Scope of network policies (IP allowlists / blocklists)
• MFA (multi-factor authentication) configuration and Duo Security integration
• Federated authentication (SSO) and SCIM provisioning

Domain 3: Data Transformation (20%)

• When to use SQL UDFs vs JavaScript UDFs vs External Functions
• Execution context of stored procedures (JavaScript / Snowflake Scripting / Python)
• Differences between Standard Views, Secure Views, and Materialized Views
• Patterns for combining Streams (Change Data Capture) with Tasks

Domain 4: Data Loading (10%)

• COPY INTO options (ON_ERROR / PURGE / FORCE / MATCH_BY_COLUMN_NAME)
• Differences between Internal Stages (User / Table / Named) and External Stages
• Snowpipe's auto-ingest mechanisms (SQS notifications / REST API)
• File format options (CSV / JSON / Parquet / Avro / ORC)

Domain 5: Data Protection & Sharing (10%)

• Time Travel (0-90 days) and Fail-Safe (7 days, accessible only by Snowflake)
• How Zero-Copy Clone works and its impact on storage
• Data Sharing (Provider / Consumer / Reader Account)
• Data protection via Secure Views and their impact on query optimization

Domain 6: Performance & Tuning (15%)

• Decision criteria for scaling up (larger warehouse size) vs scaling out (multi-cluster)
• How to read the Query Profile (spilling, pruning rate, join order)
• When to define clustering keys (tables over 1 TB, high-cardinality columns)
• Resource Monitor configuration and notify/suspend actions

Study Strategy and Roadmap

Plan on 4-6 weeks of study. Progressing through the following phases is the most efficient approach:

Exam-Day Tactics

• 100 questions in 115 minutes works out to about 69 seconds each. Flag anything you're unsure about, move on, and use the remaining time to revisit them.
• Multiple response questions explicitly state how many answers to choose (e.g., "Select 2"). Pick exactly that many.
• On "choose the best option" questions, eliminate choices that are technically correct but not best practice.
• On negative-form questions ("which is NOT correct"), be careful not to miss the negation in the prompt.
• Edition-difference questions (Standard vs Enterprise vs Business Critical) carry significant weight, so make sure you nail them.

How Scoring Works

The SnowPro Core exam is graded on a 1000-point scaled score. Not all 100 questions count toward your score — some are beta items that are unscored. You can't tell which questions are beta, so you have to give every question your full effort. The 750 passing score roughly corresponds to 75% accuracy, but the exact threshold shifts slightly due to scaling.

Check Your Understanding

Related Advanced Certifications

After passing SnowPro Core, you can move on to an Advanced exam in your specialty. There are 5 specialty certifications — Data Engineer, Administrator, Architect, Data Scientist, and Security Engineer — and all of them require SnowPro Core as a prerequisite.

Frequently Asked Questions