What is the Fail-safe retention period for transient and temporary tables?

The correct answer is A. 0 days. Snowflake's Fail-safe is a last-resort data recovery mechanism providing 7 days of additional retention for permanent tables beyond the Time Travel window. However, transient and temporary tables are explicitly excluded from Fail-safe - their Fail-safe period is 0 days. This is…

Storage and Data Protection

Question

Options

A0 days
B1 day
C7 days
D90 days

How the community answered

(38 responses)

A
92% (35)
B
5% (2)
D
3% (1)

Explanation

Snowflake's Fail-safe is a last-resort data recovery mechanism providing 7 days of additional retention for permanent tables beyond the Time Travel window. However, transient and temporary tables are explicitly excluded from Fail-safe - their Fail-safe period is 0 days. This is a deliberate trade-off: transient tables are designed for staging or intermediate data where storage costs must be minimized, and temporary tables exist only for the duration of a session. Neither type needs the 7-day Fail-safe safety net. This is a frequently tested distinction - permanent tables get 7-day Fail-safe; transient and temporary tables get 0 days.

Topics

#Fail-safe#transient tables#temporary tables#data retention

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice