Answer-first summary for fast verification
Answer: The table can be recovered for 1 day only and after that it is no longer available.
Transient tables in Snowflake have a Time Travel retention period of 0 or 1 day (configurable, with 1 day being the maximum). When a transient table is dropped, it enters Time Travel and can be recovered (undropped) only within this retention window. After the retention period expires (maximum 1 day), the table and its data become permanently irrecoverable. Option C correctly describes this behavior. Option A is incorrect because the table is temporarily recoverable via Time Travel. Option B is wrong because transient tables do not have Fail-safe. Option D is incorrect because recovery can be done by users within the Time Travel window without Snowflake Support assistance.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When a transient table is dropped in Snowflake, what is the outcome for that table?
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.
No comments yet.