COF-C02 practice examsIn development
SnowPro Core Certification
Snowflake from the ground up: the separation of storage, compute and services, warehouses and micro-partitions, role-based access and masking, the three caches and the query profile, stages, COPY INTO and Snowpipe, streams and tasks, and Time Travel, Fail-safe and secure data sharing.
What you get
Papers are cut from the bank and weighted like the real exam, and no question appears in two of them. Every wrong answer comes back on later days until you have it right.
What the exam covers
| Snowflake AI Data Cloud features and architecture | Not published |
| Account access and security | Not published |
| Performance concepts | Not published |
| Data loading and unloading | Not published |
| Data transformations | Not published |
| Data protection and data sharing | Not published |
Two sample questions
1. What are Snowflake's three architectural layers?
- Storage, query processing and cloud services — correct
- Web, app and database when in use
- Client, proxy and server as configured for this environment
- Edge, core and cloud for this instance
Why: Snowflake separates storage, compute and cloud services.
2. What does partitions scanned versus total indicate?
- Pruning effectiveness — correct
- Storage cost in practice
- Region count
- Edition level
Why: The ratio shows pruning effectiveness.
The real COF-C02 exam
| Length | 115 minutes |
|---|---|
| Questions | 100 |
| Pass mark | 750 on a scale of 0 to 1000 |
| Price | $175 USD |
| Recommended before you sit it | None, though Snowflake recommends six months of hands-on experience. |
| Valid for | 2 years |
Exam facts as published by Snowflake; always check the vendor’s page before you book.
Study COF-C02 with Chiron
Chiron is invitation-only while we are in beta, and nothing is for sale yet: invited accounts use every paper, drill and course note for free.