SnowPro Core (COF-C03) is organised into six topic areas. This is a plain-English summary. Snowflake does not publish a fixed percentage weight for each area, so prepare broadly across all six; the official Snowflake certification page is authoritative.
| # | Topic area |
|---|---|
| 1 | Snowflake AI Data Cloud features and architecture |
| 2 | Account access and security |
| 3 | Performance concepts |
| 4 | Data loading and unloading |
| 5 | Data transformations |
| 6 | Data protection and data sharing |
1 - Snowflake AI Data Cloud features and architecture
The multi-cluster shared-data architecture and its three independent layers - storage, compute (virtual warehouses) and cloud services - plus micro-partitions, the service editions and the core platform features. This area underpins the rest of the exam.
2 - Account access and security
Role-based access control (RBAC): how privileges are granted to roles and roles to users, the role hierarchy and inheritance, the system-defined roles, authentication, network policies and column-level security such as dynamic data masking.
3 - Performance concepts
Sizing and scaling virtual warehouses (up for power, out for concurrency), the caching layers, clustering keys and micro-partition pruning, and how compute credits relate to cost. The focus is reasoning about why a query is fast and what it consumes.
4 - Data loading and unloading
Stages (internal and external, such as an S3 bucket), the COPY INTO command for bulk loading and unloading, Snowpipe for continuous automated loading, and file formats and basic load options.
5 - Data transformations
Working with semi-structured data using the VARIANT type and FLATTEN, plus views (including secure and materialized views), user-defined functions, stored procedures, sequences and estimation functions.
6 - Data protection and data sharing
Continuous Data Protection - Time Travel, Fail-safe and zero-copy cloning - and secure data sharing, reader accounts and the Snowflake Marketplace. Be clear on the difference between Time Travel (user-controlled) and Fail-safe (Snowflake-managed).