Answer-first summary for fast verification
Answer: Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
Snowflake's Fail-safe feature provides a 7-day period after the Time Travel retention period expires during which historical data is recoverable. However, unlike Time Travel which allows user-initiated recovery, Fail-safe data can only be recovered by Snowflake Support and is intended for extreme scenarios like data corruption or accidental deletion beyond Time Travel. Option C correctly states both the 7-day duration and the Snowflake Support-only recovery requirement. Option A and D are incorrect because they mention 1-day duration, which applies to transient tables, not permanent tables. Option B is incorrect because it suggests user operations can recover Fail-safe data, when in reality only Snowflake Support can perform Fail-safe recoveries.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How does Snowflake's Fail-safe feature protect data in permanent tables?
A
Fail-safe makes data available up to 1 day, recoverable by user operations.
B
Fail-safe makes data available for 7 days, recoverable by user operations.
C
Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
D
Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
No comments yet.