SnowPro Core Certification — Question 646

Which table type is no longer available after the close of the session and therefore has no Fail-safe or Time Travel recovery option?

Answer options

• A. External
• B. Permanent
• C. Temporary
• D. Transient

Correct answer: C

Explanation

The correct answer is C, Temporary, because temporary tables exist only during the session in which they were created and do not support Fail-safe or Time Travel. Options A, B, and D are incorrect as External, Permanent, and Transient tables retain their data and recovery features beyond the session's duration.