Question 550
A Snowflake acceptance test follows this incident: A team wants a historical snapshot of a supported table at the state before a mistaken DELETE within retention. What evidence most directly proves the correction?
Explanation
Correct Answer
The snapshot contains pre-delete rows while the current table retains its later changes. This validates the relevant action: Use supported CLONE AT/BEFORE or Time Travel query syntax at an eligible point in history. The underlying Snowflake behavior is: Time Travel historical access can be combined with supported cloning within the defined retention period.
Incorrect Answers
Recovered table data matches the point within its permitted Time Travel retention window. This evidence tests a DIFFERENT situation: A developer asks to recover a table dropped yesterday within its configured retention window. The correction required in this case is: Use supported CLONE AT/BEFORE or Time Travel query syntax at an eligible point in history.
The clone is initially created quickly with shared underlying storage, while later mutations may increase billed storage. This evidence tests a DIFFERENT situation: A developer clones a large table for integration testing and budgets for an immediate full physical data copy. The correction required in this case is: Use supported CLONE AT/BEFORE or Time Travel query syntax at an eligible point in history.
Existing tables remain queryable after a different warehouse resumes, without reloading stored data. This evidence tests a DIFFERENT situation: An ingest warehouse is stopped for a maintenance window, but an application owner fears that stored fact tables will disappear. The correction required in this case is: Use supported CLONE AT/BEFORE or Time Travel query syntax at an eligible point in history.