Question 40
A permanent table's Time Travel period passed and extreme recovery help is needed. Which protection may still apply?
Explanation
Correct Answer
Correct: Fail-safe recovery is handled by Snowflake after Time Travel. Fail-safe provides a separate Snowflake-managed best-effort recovery period for permanent data.
Incorrect Answers
Time Travel provides historical table access during configured retention, but does not provide Fail-safe support after expiry, clone an independent environment, or replicate to another region. The scenario instead selects Fail-safe, as indicated by the stated operational requirement.
Not the best choice: Zero-copy cloning creates a separate snapshot-like object using existing storage references initially; the scenario instead requires Fail-safe recovery is handled by Snowflake after Time Travel.
Not the best choice: Database replication copies supported account/database data and metadata for cross-region or cross-account continuity; the scenario instead requires Fail-safe recovery is handled by Snowflake after Time Travel.