SnowPro Core Certification
COF-C03 Articles & Study Guides
Explore focused explanations and study guides for SnowPro Core Certification Exam.
16 articles published
Start here
01 · Study & Preparation · Guide
Data Protection with Time Travel, Fail-safe, and Zero-copy Cloning
Snowflake Time Travel, Fail-safe, and cloning all interact with historical data, but they serve different operators and outcomes. Time Travel supports customer-controlled historical queries, cloning, and restoration within retention.
Explore COF-C03 articles
Showing 1–12 of 16 articles
01 · Study & Preparation · Guide
Data Protection with Time Travel, Fail-safe, and Zero-copy Cloning
Snowflake Time Travel, Fail-safe, and cloning all interact with historical data, but they serve different operators and outcomes. Time Travel supports customer-controlled historical queries, cloning, and restoration within retention.
02 · Study & Preparation · Guide
Snowflake Query Performance and Cost Optimization
Snowflake optimization should begin with evidence, not a favorite feature. Query latency can come from queueing, compilation, scanning, spill, joins, network transfer, blocking, or an unsuitable compute profile.
03 · Study & Preparation · Guide
Monitoring Queries, Warehouses, Storage, and Account Activity
Snowflake monitoring is an evidence-selection problem.
04 · Study & Preparation · Guide
Snowflake Connectivity: Drivers, Connectors, Network Policies, and Authentication
A Snowflake connection crosses several independent controls: endpoint discovery, network reachability, Transport Layer Security (TLS), authentication, session policy, role selection, and object authorization.
05 · Study & Preparation · Guide
Snowflake SQL Transformation, Streams, Tasks, and Pipeline Patterns
Snowflake transformation pipelines combine declarative SQL with objects that track change and schedule work.
06 · Study & Preparation · Guide
Working with Structured, Semi-structured, and Unstructured Data
Snowflake supports structured, semi-structured, and unstructured data, but each category has a different representation and access pattern.
07 · Study & Preparation · Guide
Unloading Data and Building Reliable Export Workflows
Snowflake unloading exports table data or query results to files in an internal or external stage. The controlling command is COPY INTO <location>, which reverses the direction of a table load.
08 · Study & Preparation · Guide
Loading Data with Stages, File Formats, COPY INTO, and Snowpipe
Reliable Snowflake loading begins by separating four responsibilities: where files arrive, how their bytes should be interpreted, which ingestion mechanism should process them, and what evidence proves the load succeeded.
09 · Study & Preparation · Guide
Virtual Warehouses: Sizing, Scaling, Concurrency, and Cost
A Snowflake virtual warehouse supplies compute for queries and Data Manipulation Language (DML) operations, including table loads. Warehouses are independent of persisted database storage and independent of one another.
10 · Study & Preparation · Guide
Managing Snowflake Accounts, Organizations, Roles, and Access
Snowflake administration spans organization-level account management and account-level control of users, roles, privileges, and objects. Effective governance depends on placing each responsibility at the correct scope.
11 · Study & Preparation · Guide
Snowflake Objects, Micro-partitions, and Data Organization
Snowflake data organization has two connected views. Users work with logical objects such as databases, schemas, tables, and views.
12 · Study & Preparation · Guide
Snowflake Architecture: Storage, Compute, and Cloud Services
Snowflake architecture separates database storage, compute, and cloud services while presenting them as one managed platform.