SnowPro COF-C02 Glossary: Core Concepts, Loading, and Security Terms

April 14, 2026

SnowPro COF-C02 glossary of Snowflake architecture, security, loading, performance, and protection terms.

On this page

Use this glossary when Snowflake COF-C02 terms start to blur together. Keep it beside the cheat sheet and resources instead of using it as a substitute for the lessons.

High-yield terms

Term	Short meaning	Why it matters on `COF-C02`
Virtual warehouse	Snowflake compute cluster for queries, loads, and transforms	Core compute and cost term
Cloud services	Control layer for metadata, auth, optimization, and coordination	Core architecture boundary
Micro-partition	Internal Snowflake storage unit that affects pruning	Core storage and performance term
Stage	Snowflake file location used for load or unload operations	Core data-movement term
File format	Object that tells Snowflake how staged data should be parsed	Common loading boundary
Snowpipe	Managed continuous file-ingest service	Commonly confused with ordinary batch `COPY INTO`
Role	Permission set used to grant privileges	Core security term
Ownership	Control privilege on an object	Commonly confused with simple usage grants
Query profile	Execution details view used to diagnose query behavior	High-value performance term
Result cache	Reuse of prior query output when conditions match	Common performance and cost term
`VARIANT`	Snowflake type for semi-structured data such as JSON	Core transformation term
`FLATTEN`	Function used to expand nested semi-structured elements into rows	Common semi-structured clue
Time Travel	Historical access and restore within retention	Core recovery term
Fail-safe	Additional Snowflake-managed recovery layer after Time Travel	Commonly confused with Time Travel
Zero-copy clone	Point-in-time duplicate object that initially reuses storage	Commonly confused with share and restore
Secure share	Cross-account data access without copying underlying storage to the consumer	Core collaboration term

Commonly confused pairs

Pair	Keep this distinction clear
warehouse vs database	compute resource versus data container
role vs user	permission set versus principal
stage vs table	file landing location versus structured data object
file format vs stage	parsing rules versus file location
Snowpipe vs `COPY INTO`	managed continuous ingest versus direct load action
clone vs Time Travel	duplicate object versus historical recovery
secure share vs unload	live governed access versus exported files
Time Travel vs Fail-safe	self-service historical access versus Snowflake-managed later recovery

Fast recall anchors

warehouse: compute
database/schema/object: organization
role: permission set
stage: file boundary
Snowpipe: continuous ingest
VARIANT: semi-structured container
clone: duplicate object
Time Travel: history access
secure share: collaboration without copy

If three terms blur together

Cluster of terms	Clean mental split
warehouse vs micro-partition vs result cache	compute vs storage layout vs reused output
stage vs file format vs `COPY INTO`	location vs parsing rule vs load action
role vs ownership vs grant	permission set vs control of object vs specific privilege assignment
clone vs Time Travel vs secure share	duplicate vs recover vs expose data

If the confusion is really about…

Topic family	Best page to revisit
architecture and performance	Cheat Sheet
version timing and official links	Resources
pacing and review order	Study Plan
overall exam framing	Guide root

Revised on Sunday, May 10, 2026

Resources