The is the minimum Fail-safe retention time period for transient tables?

Question

Options

• A1 day
• B7 days
• C12 hours
• D0 days

• A
  4% (2)
• B
  16% (9)
• C
  9% (5)
• D
  71% (40)

Explanation

Option D is correct because transient tables in Snowflake have a Fail-safe period of 0 days - they have no Fail-safe protection at all. This is by design: transient tables exist to reduce storage costs for staging or short-lived data, and the trade-off is losing both Fail-safe recovery and extended Time Travel.

• A (1 day) is wrong but tempting - 1 day is the maximum Time Travel retention period for transient tables, not the Fail-safe period.
• B (7 days) is wrong because 7 days is the Fail-safe period for permanent tables, not transient ones.
• C (12 hours) is a distractor with no basis in Snowflake's storage model for either table type.

Memory tip: Think "Transient = no safety net." Transient tables sacrifice Fail-safe (and limit Time Travel to 0–1 day) in exchange for lower storage costs - if you need Fail-safe, use a permanent table.

No community discussion yet for this question.