Question 660
For this Snowflake situation — A data engineer expects Time Travel to restore a table that was purged outside its eligible retention period. — the team adopts: Use a separately validated backup or replication strategy rather than promising unlimited Time Travel. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Record retention settings and test recovery limits in disaster recovery plans. It controls the recurring exposure associated with this mechanism: Time Travel is bounded by object type, edition, configured retention, and elapsed time. The original action, use a separately validated backup or replication strategy rather than promising unlimited Time Travel., still needs operational checks when the environment or workload changes.
Incorrect Answers
That safeguard is relevant to: Snowflake supports restoring eligible dropped objects during their configured Time Travel period. The current failure instead follows from: Time Travel is bounded by object type, edition, configured retention, and elapsed time. Its prevention measure is “Record retention settings and test recovery limits in disaster recovery plans”.
This routine guards against another mechanism: Live shares preserve the provider's ability to manage access; exported copies cannot be centrally recalled. The recurring exposure in the current case is: Time Travel is bounded by object type, edition, configured retention, and elapsed time. The matching preventive check is “Record retention settings and test recovery limits in disaster recovery plans”.
The suggested review tracks a different technical risk: Discovery through a listing does not eliminate provider object authorization and product access controls. Here the sustained control must address: Time Travel is bounded by object type, edition, configured retention, and elapsed time. Choose “Record retention settings and test recovery limits in disaster recovery plans”.