Answer-first summary for fast verification
Answer: The table can be recovered because the table retention period default is at the database level.
The correct answer is B because when DATA_RETENTION_TIME_IN_DAYS is set at the database level (30 days in this case) and not explicitly set for individual tables, the table inherits the database-level retention period. Since the table was dropped after only 5 days, it falls well within the 30-day retention window and can be recovered using Time Travel. Option A is incorrect because it states the user can recover after 30 days, which contradicts the scenario where recovery is needed at 5 days. Option C is incorrect because Fail-safe is only for longer-term recovery beyond the Time Travel period and requires Snowflake Support, which is not needed here. Option D is incorrect because the table does inherit the database-level retention setting, making recovery possible.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A user created a database with DATA_RETENTION_TIME_IN_DAYS set to 30 but did not explicitly set DATA_RETENTION_TIME_IN_DAYS for table T1. After 5 days, the user accidentally drops table T1.
What are the considerations for recovering table T1?
A
The user can recover the table T1 after 30 days.
B
The table can be recovered because the table retention period default is at the database level.
C
The table can only be recovered by contacting Snowflake Support to recover the table from Fail-safe.
D
The table cannot be recovered because the DATA_RETENTION_TIME_IN_DAYS was not set for table T1.