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 5 domains. Snowflake AI Data Cloud Features & Architecture (31%) and Performance Optimization, Querying, and Transformation (21%) together account for 52% of the exam, so mastering these two areas largely determines whether you pass.

Study Focus for Each Domain

Domain 1: Features & Architecture (31%)

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)
• Feature differences across Standard / Enterprise / Business Critical / VPS editions
• Decision criteria for scaling up (larger warehouse size) vs scaling out (multi-cluster)
• Differences between Standard Views, Secure Views, and Materialized Views
• When to use SQL UDFs vs JavaScript UDFs vs External Functions
• Execution context of stored procedures (JavaScript / Snowflake Scripting / Python)
• What Snowflake Cortex (AI SQL functions, Cortex Search, Cortex Analyst), Snowpark, and Streamlit in Snowflake are used for

Domain 2: Account Management & Data Governance (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
• Data governance with data masking, row access policies, and object tagging
• Resource Monitor configuration and notify/suspend actions

Domain 3: Data Loading, Unloading & Connectivity (18%)

• 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)
• Patterns for combining Streams (Change Data Capture) with Tasks
• The roles of drivers, connectors, and storage integrations

Domain 4: Performance Optimization, Querying & Transformation (21%)

• How to read the Query Profile (spilling, pruning rate, join order)
• The three cache types (Result Cache / Metadata Cache / Warehouse Cache): where each is stored and what invalidates them
• When to define clustering keys (tables with multiple terabytes of data; columns whose cardinality is neither very low nor very high)
• When to use the Search Optimization Service and the Query Acceleration Service
• Working with semi-structured data (VARIANT / FLATTEN) and window functions

Domain 5: Data Collaboration (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
• The difference between public listings on the Snowflake Marketplace and private listings

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 differences (Standard vs Enterprise vs Business Critical) are an objective (1.1) in Domain 1.0, the highest-weighted domain (31%), so make sure you nail them.

How Scoring Works

The SnowPro Core exam is graded on a 1000-point scaled score. The exam may include unscored items that Snowflake uses to gather statistics for future exams; they do not affect your score. Unscored items are not identified on the exam, so you have to give every question your full effort. The 750 passing score is not a percentage of correct answers. Snowflake explains that it uses scaled scoring so that results stay consistent across exam forms, item difficulty, and versions, and that it sets passing scores through statistical analysis. Snowflake does not publish what percentage of correct answers 750 corresponds to.

Check Your Understanding

Related Advanced Certifications

After passing SnowPro Core, you can move on to an Advanced exam in your specialty. As of October 2026, there are 7 Advanced certifications — Architect, Data Engineer, Administrator, Data Analyst (retiring December 1, 2026), Data Scientist (retiring November 1, 2026), Security Engineer (retiring December 1, 2026), and MLOps Engineer — and all of them require an active SnowPro Core certification.

Frequently Asked Questions