SnowPro Core Certification — Question 150

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

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because Snowflake's Fail-safe feature retains data for 7 days, but it can only be recovered by Snowflake Support, ensuring that users cannot access it directly. Options A and D incorrectly state the duration of data retention, while option B incorrectly suggests that users can recover the data themselves.