Snowflake
COF-R02 · Question #276
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. See the full explanation below for the reasoning.
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
(52 responses)- A2% (1)
- B12% (6)
- C81% (42)
- D6% (3)
Community Discussion
No community discussion yet for this question.