
Explanation:
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.
Ultimate access to all questions.
No comments yet.
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.