SnowPro Core Certification — Question 204

What are the default Time Travel and Fail-safe retention periods for transient tables?

Answer options

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

Correct answer: C

Explanation

The correct answer is C, as transient tables have a Time Travel retention period of 1 day and do not have a Fail-safe period. Options A and B incorrectly state the Fail-safe duration, while option D incorrectly suggests that Time Travel is also not available for transient tables.