Answer-first summary for fast verification
Answer: Creating a clone of an entire table at a specific point in the past from a permanent table
The correct answer is C because Time Travel in Snowflake specifically allows creating clones of tables at specific points in the past, which is a core Time Travel feature documented in Snowflake's official documentation. Option A is incorrect because Time Travel cannot restore tables from data shares - it only works within the same account. Option B is incorrect because Time Travel retention periods are fixed based on table type (1 day for transient, up to 90 days for permanent) and cannot be extended beyond these limits. Option D is incorrect because setting DATA_RETENTION_TIME_IN_DAYS to NULL disables Time Travel rather than being an operation performed using Time Travel. The community discussion shows 100% consensus on answer C with upvoted comments referencing Snowflake's official Time Travel documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which of the following operations can be performed using Snowflake Time Travel?
A
Restoring tables that have been dropped from a data share
B
Extending a permanent table’s retention duration from 90 to 100 days
C
Creating a clone of an entire table at a specific point in the past from a permanent table
D
Disabling Time Travel for a specific object by setting DATA_RETENTION_TIME_IN_DAYS to NULL
No comments yet.