SnowPro Core Certification — Question 782

What is the Fail-safe retention period for transient and temporary tables?

Answer options

• A. 0 days
• B. 1 day
• C. 7 days
• D. 90 days

Correct answer: A

Explanation

The correct answer is A, as transient and temporary tables are retained for a fail-safe period of 0 days, meaning they are not retained after the session ends. Options B, C, and D imply longer retention periods which do not apply to these types of tables.