SnowPro Core Certification (COF-C02 / COF-C03)
Demonstrate comprehensive fluency in the Snowflake Data Cloud, covering data loading and transformation, performance tuning, clustering keys, virtual warehouses, security, governance, and data sharing.
Official Exam Specification & Quick Facts
Question Difficulty Breakdown
Exam Guidelines & Simulation Rules
Frequently Asked Questions (FAQ)
The SnowPro Core exam features 100 multiple-choice and multi-select questions over 115 minutes. Cost is $175 USD, with a passing scaled score of 750/1000 (75%).
Domains include: (1) Snowflake Data Cloud Features and Architecture (~25%), (2) Account Access and Security (~20%), (3) Performance Concepts (~15%), (4) Data Loading and Unloading (~20%), (5) Data Transformations (~15%), and (6) Data Protection and Data Sharing (~10%).
COPY INTO is a batch loading command executed using user-managed virtual warehouses. Snowpipe is a serverless, continuous data loading service that automatically loads files within seconds of arrival in cloud storage using micro-batches.
Snowflake partitions data automatically; clustering keys should only be defined on very large tables (multi-terabyte) with high query selectivity that query specific filter columns frequently to optimize partition pruning.
The three layers are: (1) Result Cache (stores query results for 24 hours in Cloud Services layer, 0 compute cost), (2) Local Disk Cache / Warehouse Cache (raw data cached on local SSDs of running warehouse nodes), and (3) Remote Storage (persistent S3/Azure/GCS storage).
Snowflake natively stores semi-structured data in the `VARIANT` data type, automatically shredding sub-columns into columnar storage and allowing SQL dot-notation or colon-notation (`src:customer.id`) querying.
A Stream records Change Data Capture (CDC) deltas (inserts, updates, deletes) on a table. A Task executes scheduled SQL statements or stored procedures, frequently paired with Streams to build automated ELT pipelines.
Dynamic Data Masking is a column-level security feature that masks sensitive data (SSN, credit card) in query results for unauthorized roles using masking policies while preserving plain text on disk.
Tri-Secret Secure combines a customer-managed key in AWS KMS / Azure Key Vault, a Snowflake-managed key, and user credentials to create a dual-key composite encryption hierarchy for data at rest.
A Reader Account is a consumer account provisioned and funded entirely by the data provider, enabling third-party organizations without a Snowflake account to query shared datasets.
SnowPro Core is valid for two years. Certified professionals must pass the SnowPro Core Recertification exam or achieve a SnowPro Advanced certification to renew.
SnowPro Core is the industry standard certification for Snowflake Data Engineers, Cloud Architects, and Analytics Consultants earning average US salaries between $125,000 and $165,000.