COF-C02 · Question #170
What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)
The correct answer is C. The clone is created almost instantly. E. The clone saves space by not duplicating storage. Snowflake's zero-copy cloning works by creating a new metadata pointer to the existing micro-partitions rather than physically copying data, which means: (C) clones are created nearly instantaneously regardless of table size, and (E) no additional storage is consumed at clone…
Question
What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)
Options
- AThe clone always stays in sync with the original table.
- BThe clone has better query performance.
- CThe clone is created almost instantly.
- DThe clone will have time travel history from the original table.
- EThe clone saves space by not duplicating storage.
How the community answered
(32 responses)- A3% (1)
- B6% (2)
- C88% (28)
- D3% (1)
Explanation
Snowflake's zero-copy cloning works by creating a new metadata pointer to the existing micro-partitions rather than physically copying data, which means: (C) clones are created nearly instantaneously regardless of table size, and (E) no additional storage is consumed at clone creation - storage only grows as the clone and source diverge through DML changes. Option A is incorrect because clones and source tables diverge independently after creation. Option B is incorrect because clones have no inherent query performance advantage. Option D is incorrect because a clone starts its own independent time travel history from the point of creation; it does not inherit the source table's prior time travel history.
Topics
Community Discussion
No community discussion yet for this question.