Question 190
A Snowflake administrator investigates the following production situation: An operator accidentally deletes records from a permanent table and wants to inspect the data as it existed an hour earlier within retention. Which underlying issue should be investigated first?
Explanation
Correct Answer
The described symptoms indicate that the required historical state is recoverable through configured Time Travel retention. The appropriate resolution is: Use supported Time Travel queries or recovery operations within the allowed retention interval. Confirm with: The recovered sample matches the prior table state without relying on nightly flat-file backups.
Incorrect Answers
Zero-copy cloning can reuse existing micro-partitions until changes create new storage. “Create an authorized zero-copy clone for the isolated test requirement” would address that alternative cause, not the condition in this question: the required historical state is recoverable through configured Time Travel retention.
“Use appropriately configured Time Travel or backups for ordinary historical recovery needs” responds to this separate finding: fail-safe is a last-resort recovery mechanism rather than a routine user query feature. This question instead needs “Use supported Time Travel queries or recovery operations within the allowed retention interval”, so the alternative does not meet the stated condition.
Clones become independent logical objects whose later data changes do not automatically propagate. “Keep development writes in the cloned object and verify source and clone identities before execution” applies to that separate problem. The observed case is an operator accidentally deletes records from a permanent table and wants to inspect the data as it existed an hour earlier within retention; choosing this alternative would address the wrong failure mode.