Answer-first summary for fast verification
Answer: The transient table version cannot be retrieved after 24 hours.
The correct answer is B because transient tables in Snowflake have a maximum Time Travel retention period of 1 day (24 hours), regardless of the DATA_RETENTION_TIME_IN_DAYS setting. Since the user is trying to retrieve data from 3 days ago, which exceeds the 24-hour limit for transient tables, the data cannot be retrieved through Time Travel. Option A is incorrect because DATA_RETENTION_TIME_IN_DAYS cannot be set to more than 1 day for transient tables. Option C is incorrect because Fail-safe is not accessible to users and is only for Snowflake internal recovery purposes. Option D is incorrect because there is no FAIL_SAFE parameter for Time Travel - Fail-safe is a separate, non-user-accessible storage mechanism. The community discussion shows strong consensus for answer B with 88% of users selecting it and multiple comments confirming that transient tables only support 0-1 day Time Travel retention.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A user created a transient table and has modified it over several days. Three days after its creation, the user wants to restore the table to its original, first version.
How can this be achieved?
A
Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
B
The transient table version cannot be retrieved after 24 hours.
C
Contact Snowflake Support to have the data retrieved from Fail-safe storage.
D
Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.
No comments yet.