COF-C03 Practice Question: Snowflake AI Data Cloud Features and Architecture
A data architect is designing a solution that requires zero-copy cloning of a production database for testing purposes. The clone must be created quickly and should not duplicate storage until changes are made. Which Snowflake feature should they use?
⚠ Common exam trap
The trap here is assuming that any CREATE DATABASE statement can clone, when only the CLONE keyword provides zero-copy cloning.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
CREATE DATABASE ... CLONE
CREATE DATABASE ... CLONE performs a zero-copy clone, which duplicates only metadata and references existing micro-partitions. This allows rapid creation of a clone without immediate storage costs. Subsequent changes to the clone or source create new micro-partitions, preserving isolation. Other options either copy data physically or serve different purposes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
UNDROP DATABASE
Why it's wrong here
UNDROP DATABASE restores a previously dropped database within the Time Travel retention period. It is not used for cloning; it recovers a dropped database. This does not create a new independent copy for testing and is not a zero-copy operation.
- ✓
CREATE DATABASE ... CLONE
Why this is correct
The CREATE DATABASE ... CLONE command creates a zero-copy clone of a database. It copies metadata and references the same micro-partitions as the source, so no additional storage is consumed initially. Changes to either the source or the clone create new micro-partitions, ensuring isolation. This meets the requirement for rapid cloning without immediate storage duplication.
- ✗
CREATE DATABASE ... FROM SHARE
Why it's wrong here
CREATE DATABASE ... FROM SHARE creates a database from a share provided by another account. It is used for data sharing, not for cloning within the same account. It does not provide a zero-copy clone of an existing database and would not meet the testing scenario's need for an independent, modifiable copy.
- ✗
CREATE DATABASE ... AS SELECT
Why it's wrong here
CREATE DATABASE ... AS SELECT creates a new database by copying data from a query, which physically duplicates the data and consumes storage immediately. It is not a zero-copy operation and would take time proportional to the data size. This does not satisfy the requirement for quick cloning without storage duplication.
About these practice questions
Courseiva writes every COF-C03 question from scratch — 280 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Snowflake exam blueprint
This COF-C03 practice question is part of Courseiva's free Snowflake certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the COF-C03 exam.