SnowPro Core Certification — Question 1169

When a transient table in Snowflake is dropped, what happens to the table?

Answer options

• A. The table is no longer available for use.
• B. The table can be undropped using Fail-safe.
• C. The table can be recovered for 1 day only and after that it is no longer available.
• D. The table can be recovered only with the assistance of Snowflake Support.

Correct answer: C

Explanation

When a transient table is dropped in Snowflake, it can be recovered for only 1 day before it becomes permanently unavailable. Options A and B are incorrect because they misrepresent the availability and recovery options for transient tables. Option D is also wrong, as Snowflake Support is not required for recovery within the 1-day window.