How long is the Fail-safe period for temporary and transient tables?

The correct answer is A. There is no Fail-safe period for these tables. Temporary and transient tables in Snowflake have NO Fail-safe period (A). Fail-safe is a disaster-recovery feature that provides a 7-day window after the Time Travel period expires during which Snowflake (not the user) can recover data - but only for permanent tables. Temporary…

Storage and Data Protection

Question

Options

AThere is no Fail-safe period for these tables.
B1 day
C7 days
D31 days
E90 days

How the community answered

(56 responses)

A
88% (49)
B
2% (1)
D
4% (2)
E
7% (4)

Explanation

Temporary and transient tables in Snowflake have NO Fail-safe period (A). Fail-safe is a disaster-recovery feature that provides a 7-day window after the Time Travel period expires during which Snowflake (not the user) can recover data - but only for permanent tables. Temporary tables exist only for the duration of a session and are dropped automatically when the session ends. Transient tables are designed for short-lived data where lower storage costs are a priority and are intentionally excluded from Fail-safe to reduce storage charges. Both table types also support a reduced or zero Time Travel period. Understanding table types and their Time Travel/Fail-safe characteristics is a key Snowflake exam topic.

Topics

#Fail-safe#Temporary tables#Transient tables#Data retention policy

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice