Past objects that were dropped can no longer be restored.

• A. True
• B. False
• C. Only if backup exists
• D. Not restorable after end

Answer: (A)

Recovery of dropped objects is controlled by retention windows. When something is dropped, Snowflake keeps the data accessible for the Time Travel period. During that window you can restore the object (undrop or time-travel to a point before the drop). After Time Travel ends, the data moves into the Fail-Safe period, and once that Fail-Safe window has passed, the object cannot be restored. So, for past objects that were dropped, restoration is not possible once both retention windows have ended. That’s why this statement is true in practice: beyond the allowable recovery windows, dropped objects cannot be restored. If you’re still within the retention windows, restoration is possible, but outside them, it isn’t.