Which objects will incur storage costs associated with Fail-safe?

The correct answer is D. Data files available in external stages. NOTE: Based on Snowflake documentation, this answer (D) appears to be incorrect. Fail-safe is a Snowflake feature that provides an additional 7-day data recovery window after the Time Travel retention period expires, and it applies only to PERMANENT TABLES (answer B). Transient…

Storage and Data Protection

Question

Options

AExternal tables
BPermanent tables
CData files available in internal stages
DData files available in external stages

How the community answered

(13 responses)

A
15% (2)
B
8% (1)
C
8% (1)
D
69% (9)

Explanation

NOTE: Based on Snowflake documentation, this answer (D) appears to be incorrect. Fail-safe is a Snowflake feature that provides an additional 7-day data recovery window after the Time Travel retention period expires, and it applies only to PERMANENT TABLES (answer B). Transient and temporary tables have no Fail-safe period. Data files in external stages are stored in external cloud storage (e.g., S3, Azure Blob) and are not managed by Snowflake's Fail-safe mechanism. External tables also have no Fail-safe. If you encounter this question on an exam, be aware that Permanent Tables are the canonical correct answer for objects that incur Fail-safe storage costs.

Topics

#Fail-safe#Storage Costs#External Stages#Data Retention

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice