SnowPro Core Certification — Question 281

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

Answer options

• 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.

Correct answer: C, E

Explanation

The correct answers are C and E because clones are created almost instantly without the need for time-consuming data copying, and they save space since they do not duplicate the original table's storage. Options A and D are incorrect because clones do not maintain synchronization with the original table, nor do they inherit time travel history; they are independent entities.