Answer-first summary for fast verification
Answer: Time Travel - 1 day, Failsafe - 0 days
The correct answer is C because transient tables in Snowflake have a default Time Travel retention period of 1 day and no Fail-safe period (0 days). According to Snowflake documentation and the community consensus (with multiple upvoted comments confirming this), transient tables support Time Travel for either 0 or 1 day by default, but they do not have Fail-safe protection. Option A is incorrect because transient tables have no Fail-safe period. Option B is wrong as transient tables do have Time Travel (1 day by default). Option D is incorrect because transient tables do support Time Travel.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What are the default Time Travel and Fail-safe retention periods for a transient table in Snowflake?
A
Time Travel - 1 day, Fail-safe - 1 day
B
Time Travel - 0 days, Fail-safe - 1 day
C
Time Travel - 1 day, Failsafe - 0 days
D
Transient tables are retained in neither Fail-safe nor Time Travel.
No comments yet.