Search...

Quick Feedback

SnowPro Core Study Guide

Domain-by-domain study guide for SnowPro Core Certification (COF-C03). Covers all 6 exam objectives with topic checklists, quick notes, and practice links.

Download PDF Notes

Exam Overview

Key facts before you start studying

Duration

115 min

Questions

100

Exam Code

COF-C03

Domains

Quick Navigation

Jump to a specific exam domain

1. Snowflake AI Data Cloud Features & Architecture (25%)
2. Account Access and Security (17%)
3. Performance Concepts (15%)
4. Data Loading and Unloading (15%)
5. Data Transformations (17%)
6. Data Protection and Data Sharing (11%)

Domain 1

25%

Snowflake AI Data Cloud Features & Architecture

Snowflake architecture, editions, and core platform capabilities

Topics to Master

Multi-cluster shared data architecture
Separation of storage and compute
Cloud layers: Storage, Compute, Cloud Services
Snowflake editions (Standard, Enterprise, Business Critical, VPS)
Virtual warehouses and multi-cluster warehouses
Data Marketplace and data sharing ecosystem
Snowflake AI/ML features: Cortex, Snowpark
Semi-structured data support (VARIANT, ARRAY, OBJECT)

Domain 2

17%

Account Access and Security

Authentication, authorization, and security controls in Snowflake

Topics to Master

Authentication: MFA, SSO/SAML, key pair, OAuth
Role-based access control (RBAC) and privilege management
System-defined roles: ACCOUNTADMIN, SYSADMIN, SECURITYADMIN, PUBLIC
Column-level security and dynamic data masking
Row access policies
Network policies and IP allow lists
Private connectivity (AWS PrivateLink, Azure Private Link)

Domain 3

15%

Performance Concepts

Query optimization, caching, and performance tuning in Snowflake

Topics to Master

Query profile and execution details
Caching layers: metadata cache, result cache, warehouse (local disk) cache
Clustering keys and micro-partition pruning
Search Optimization Service
Materialized views
Virtual warehouse sizing (X-Small through 6X-Large)
Auto-suspend and auto-resume

Domain 4

15%

Data Loading and Unloading

Ingesting and exporting data using Snowflake stages and COPY INTO

Topics to Master

Internal stages: user stage (@~), table stage (@%), named internal stage
External stages: Amazon S3, Azure Blob Storage, Google Cloud Storage
COPY INTO <table> command and options
File formats: CSV, JSON, Parquet, ORC, Avro, XML
Snowpipe for continuous/automated data ingestion
Data unloading with COPY INTO <location>
PUT and GET commands for local file transfer

Domain 5

17%

Data Transformations

SQL, semi-structured data, streams, tasks, and Snowpark

Topics to Master

DML: INSERT, UPDATE, DELETE, MERGE
DDL: CREATE, ALTER, DROP, CLONE
Transaction management: BEGIN, COMMIT, ROLLBACK
Semi-structured data querying with FLATTEN and lateral joins
Streams for change data capture (CDC)
Tasks for scheduled SQL execution and DAG workflows
Stored procedures (JavaScript, Snowflake Scripting, Python via Snowpark)
User-defined functions (UDFs): JavaScript, Python, SQL, Java

Continue Your Prep

Free CertStud resources for COF-C03

Study Notes Exam Study Plan Start Practice Test

Back to SnowPro Core

SnowPro Core Study Guide

Domain-by-domain study guide for SnowPro Core Certification (COF-C03). Covers all 6 exam objectives with topic checklists, quick notes, and practice links.

Download PDF Notes

Exam Overview

Key facts before you start studying

Duration

115 min

Questions

100

Exam Code

COF-C03

Domains

Quick Navigation

Jump to a specific exam domain

1. Snowflake AI Data Cloud Features & Architecture (25%)
2. Account Access and Security (17%)
3. Performance Concepts (15%)
4. Data Loading and Unloading (15%)
5. Data Transformations (17%)
6. Data Protection and Data Sharing (11%)

Domain 1

25%

Snowflake AI Data Cloud Features & Architecture

Snowflake architecture, editions, and core platform capabilities

Topics to Master

Multi-cluster shared data architecture
Separation of storage and compute
Cloud layers: Storage, Compute, Cloud Services
Snowflake editions (Standard, Enterprise, Business Critical, VPS)
Virtual warehouses and multi-cluster warehouses
Data Marketplace and data sharing ecosystem
Snowflake AI/ML features: Cortex, Snowpark
Semi-structured data support (VARIANT, ARRAY, OBJECT)

Domain 2

17%

Account Access and Security

Authentication, authorization, and security controls in Snowflake

Topics to Master

Authentication: MFA, SSO/SAML, key pair, OAuth
Role-based access control (RBAC) and privilege management
System-defined roles: ACCOUNTADMIN, SYSADMIN, SECURITYADMIN, PUBLIC
Column-level security and dynamic data masking
Row access policies
Network policies and IP allow lists
Private connectivity (AWS PrivateLink, Azure Private Link)

Domain 3

15%

Performance Concepts

Query optimization, caching, and performance tuning in Snowflake

Topics to Master

Query profile and execution details
Caching layers: metadata cache, result cache, warehouse (local disk) cache
Clustering keys and micro-partition pruning
Search Optimization Service
Materialized views
Virtual warehouse sizing (X-Small through 6X-Large)
Auto-suspend and auto-resume

Domain 4

15%

Data Loading and Unloading

Ingesting and exporting data using Snowflake stages and COPY INTO

Topics to Master

Internal stages: user stage (@~), table stage (@%), named internal stage
External stages: Amazon S3, Azure Blob Storage, Google Cloud Storage
COPY INTO <table> command and options
File formats: CSV, JSON, Parquet, ORC, Avro, XML
Snowpipe for continuous/automated data ingestion
Data unloading with COPY INTO <location>
PUT and GET commands for local file transfer

Domain 5

17%

Data Transformations

SQL, semi-structured data, streams, tasks, and Snowpark

Topics to Master

DML: INSERT, UPDATE, DELETE, MERGE
DDL: CREATE, ALTER, DROP, CLONE
Transaction management: BEGIN, COMMIT, ROLLBACK
Semi-structured data querying with FLATTEN and lateral joins
Streams for change data capture (CDC)
Tasks for scheduled SQL execution and DAG workflows
Stored procedures (JavaScript, Snowflake Scripting, Python via Snowpark)
User-defined functions (UDFs): JavaScript, Python, SQL, Java

Continue Your Prep

Free CertStud resources for COF-C03

Study Notes Exam Study Plan Start Practice Test