Answer-first summary for fast verification
Answer: The data moves to Fail-safe
According to Snowflake documentation and the community consensus (with 100% agreement and upvoted comments), when the data retention period for an object ends, the historical data is moved into Snowflake Fail-safe. Fail-safe is a 7-day period during which data is recoverable only by Snowflake support for disaster recovery purposes, but is no longer accessible through Time Travel queries. Option A is incorrect because data is not cloned. Option C is incorrect because Time Travel is not 'dropped' but rather the data becomes inaccessible through Time Travel. Option D is incorrect because the object itself is not dropped - only the historical data transitions to Fail-safe.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What happens to the data in a table when its defined data retention period expires?
A
The data is cloned into a historical object.
B
The data moves to Fail-safe
C
Time Travel on the historical data is dropped.
D
The object containing the historical data is dropped.