SnowPro Core
SnowPro Core Certification (COF-C02)
The Snowflake SnowPro Core Certification (COF-C02) validates foundational expertise in the Snowflake Data Cloud platform. It covers Snowflake's multi-cluster shared data architecture, virtual warehouse sizing and auto-scaling, data loading (COPY INTO, Snowpipe), transformation with Snowflake SQL, secure data sharing, role-based access control, and time travel and fail-safe features.
SnowPro Core Exam Overview
| Detail | Information |
|---|---|
| Full Name | SnowPro Core Certification (COF-C02) |
| Governing Body | Snowflake |
| Number of Questions | 100 |
| Time Limit | 115 minutes |
| Passing Score | 750/1000 |
| Exam Fee | $175 USD |
| Category | IT Certifications |
| C3RT App Available On | iPhone, iPad, and Mac |
| Official Source | Snowflake official website ↗ |
SnowPro Core Content Areas and Domains
| Domain / Content Area | Exam Weight |
|---|---|
| Snowflake Cloud Data Platform Features and Architecture | 25% |
| Account Access and Security | 20% |
| Performance Concepts | 15% |
| Data Loading and Unloading | 20% |
| Data Transformations | 20% |
Domain weights are approximate and based on the Snowflake content outline. Always verify at the official source before your exam.
Topics Covered
- ✓ Snowflake Architecture — services layer, query processing layer, database storage layer
- ✓ Virtual Warehouses — sizes, multi-cluster, auto-suspend, auto-resume, credit consumption
- ✓ Data Loading — COPY INTO, PUT, GET, external stages, Snowpipe continuous loading
- ✓ Data Transformation — Snowflake SQL functions, streams, tasks, dynamic tables
- ✓ Account Access & Security — RBAC, DAC, network policies, MFA, SSO/SAML
- ✓ Data Protection — Time Travel (0–90 days), Fail-Safe (7 days), cloning
- ✓ Data Sharing — Secure Data Sharing, Snowflake Marketplace, Data Exchange
- ✓ Performance Optimization — clustering keys, search optimization, result caching, materialized views
How C3RT Helps You Pass the SnowPro Core
Adaptive Practice
Questions adapt to your weak areas automatically so every study session on the SnowPro Core is time well spent.
Diagnostic Mocks
Full-length mock exams timed to the real SnowPro Core format with detailed score breakdowns by topic.
Mistake Bank
Every wrong answer is saved for targeted re-drill. The system resurfaces your mistakes until they stick.
Native on iOS & Mac
Built with SwiftUI, not a web wrapper. Instant load, offline support, hardware-speed rendering.
SnowPro Core Frequently Asked Questions
What does SnowPro Core stand for?
SnowPro Core stands for SnowPro Core Certification (COF-C02). It is administered by Snowflake.
Who administers the SnowPro Core?
The SnowPro Core Certification (COF-C02) (SnowPro Core) is administered by Snowflake. For official information, visit the Snowflake website.
How many questions is the SnowPro Core?
The SnowPro Core consists of 100 questions. Candidates are given 115 minutes to complete the exam.
What is the passing score for the SnowPro Core?
The passing score for the SnowPro Core is 750/1000, as set by Snowflake. Scoring methodology and passing standards may be updated periodically. Always verify current requirements with the governing body.
How much does the SnowPro Core exam cost?
The SnowPro Core exam fee is $175 USD. This fee is set by Snowflake and may vary by testing centre, region, or membership status. Additional fees for registration or rescheduling may apply.
What is the Snowflake architecture and why does it matter for the exam?
Snowflake's architecture has three distinct layers: cloud services (authentication, query optimization, metadata), query processing (virtual warehouses — isolated compute clusters), and database storage (columnar data stored in cloud object storage). This separation of compute and storage is Snowflake's key differentiator, enabling independent scaling. The exam heavily tests this architecture and its implications for performance and cost.
What is a Snowflake virtual warehouse?
A virtual warehouse is a compute cluster in Snowflake — it's what executes SQL queries and DML. Warehouses come in sizes from XS to 6XL (each size doubles credits/hour). They can auto-suspend after inactivity and auto-resume on query submission. Multi-cluster warehouses handle concurrency by spinning up additional clusters. Exam topics include warehouse sizing, credit consumption, and when to use multi-cluster.
What is Snowpipe and how does it differ from COPY INTO?
COPY INTO is a batch load command executed manually or on a schedule. Snowpipe is continuous loading — it uses event notifications (from S3, Azure Blob, GCS) to automatically load data as it arrives, typically within minutes. Snowpipe uses serverless compute and is billed per credit consumed. The exam tests when to use each approach based on latency requirements and cost.
What is Snowflake Time Travel?
Time Travel lets you query historical data at any point within its retention period (0–90 days based on your Snowflake edition and object settings). Syntax: SELECT * FROM table AT (TIMESTAMP => timestamp) or AT (OFFSET => -3600). Enterprise edition supports up to 90 days; Standard supports up to 1 day. After the Time Travel period expires, Fail-Safe provides a 7-day recovery window (accessible only by Snowflake support).
C3RT is a native iOS and macOS exam preparation platform covering the SnowPro Core Certification (COF-C02) (SnowPro Core), a IT Certifications certification, administered by Snowflake. C3RT is not affiliated with or endorsed by Snowflake. Certification names and trademarks are the property of their respective organisations. For official exam registration, eligibility requirements, and content outlines, visit the Snowflake official website ↗ .