How does Snowflake Fail-safe protect data in a permanent table?

The correct answer is C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support. Fail-safe is a Snowflake data recovery mechanism that kicks in after the Time Travel retention period expires. For permanent tables, Fail-safe retains data for exactly 7 days. Critically, this data is NOT accessible or recoverable by users or account administrators - only…

Storage and Data Protection

Question

Options

AFail-safe makes data available up to 1 day, recoverable by user operations.
BFail-safe makes data available for 7 days, recoverable by user operations.
CFail-safe makes data available for 7 days, recoverable only by Snowflake Support.
DFail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

How the community answered

(24 responses)

A
4% (1)
C
96% (23)

Explanation

Fail-safe is a Snowflake data recovery mechanism that kicks in after the Time Travel retention period expires. For permanent tables, Fail-safe retains data for exactly 7 days. Critically, this data is NOT accessible or recoverable by users or account administrators - only Snowflake Support can recover it, and only in cases of catastrophic failure. It is a last-resort safety net, not a user-facing feature.

Topics

#Fail-safe#Data Protection#Permanent Tables#Data Recovery

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice