SnowPro Core Certification — Question 1263

What happens when a table or schema with a standard retention period is dropped?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D because when a table or schema with a standard retention period is dropped, it is kept for that specified duration, allowing for data recovery if necessary. Options A and B are incorrect as they imply immediate removal or transfer to Fail-safe, which does not apply in this context. Option C is also wrong since it suggests that associated data is purged immediately, which contradicts the concept of a retention period.