Answer-first summary for fast verification
Answer: The object is retained for the data retention period.
The correct answer is D because when a table or schema with a standard retention period is dropped in Snowflake, it is not immediately deleted but retained in Time Travel for the configured retention period (default 1 day in Standard Edition). During this period, the object can be restored using the UNDROP command. Option A is incorrect because the object is not immediately removed. Option B is incorrect because objects only move to Fail-safe after the Time Travel retention period expires, not instantaneously. Option C is incorrect because the data is not immediately purged; it remains accessible during the retention period.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What happens when a table or schema with a standard retention period is dropped in Snowflake?
A
The object is immediately removed from the system.
B
The object is instantaneously moved to Fail-safe.
C
The object is retained but all associated data is immediately purged.
D
The object is retained for the data retention period.