Question 170
A test plan evaluates: A developer asks to recover a table dropped yesterday within its configured retention window. Which evidence should be required before release?
Explanation
Correct Answer
Recovered table data matches the point within its permitted Time Travel retention window. This validates the relevant action: Use UNDROP TABLE or supported Time Travel recovery according to object retention and name conflicts. The underlying Snowflake behavior is: Time Travel supports recovery of dropped supported objects while their retention remains valid.
Incorrect Answers
Time-filtered SQL queries prune eligible partitions without user-maintained folder partition definitions. This evidence tests a DIFFERENT situation: A table is manually partitioned into separate daily physical files to achieve traditional partition maintenance in regular Snowflake tables. The correction required in this case is: Use UNDROP TABLE or supported Time Travel recovery according to object retention and name conflicts.
A region-level outage drill has an independent approved recovery path rather than relying on a local clone. This evidence tests a DIFFERENT situation: A data steward uses a zero-copy clone as a replacement for a remote recovery copy in a separate cloud region. The correction required in this case is: Use UNDROP TABLE or supported Time Travel recovery according to object retention and name conflicts.
Execution timing and credits improve under measured query bursts without keeping the warehouse idle all day. This evidence tests a DIFFERENT situation: A recurring report finishes in two minutes but its warehouse auto-suspends after an extremely short idle timeout between closely spaced queries. The correction required in this case is: Use UNDROP TABLE or supported Time Travel recovery according to object retention and name conflicts.