
Answer-first summary for fast verification
Answer: The clone is created almost instantly., The clone saves space by not duplicating storage.
The question asks for two advantages of clones over CTAS tables. Option C is correct because cloning creates a new table almost instantly by referencing the original data, unlike CTAS which requires data copying. Option E is correct because clones use zero-copy cloning, sharing storage with the original table and saving space, while CTAS duplicates storage. Option A is incorrect as clones do not automatically sync with the original table after creation. Option B is incorrect because query performance is similar for both, as both reference underlying data. Option D is incorrect because clones only have time travel history from their creation point, not from the original table's history, as confirmed by community comments and Snowflake documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What are two advantages of using clones compared to tables created with the CREATE TABLE AS SELECT (CTAS) statement?
A
The clone always stays in sync with the original table.
B
The clone has better query performance.
C
The clone is created almost instantly.
D
The clone will have time travel history from the original table.
E
The clone saves space by not duplicating storage.
No comments yet.