What is the MAXIMUM Time Travel retention period for a transient table?

The correct answer is B. 1 day. Transient tables in Snowflake are designed for temporary, non-critical data and intentionally have reduced durability features to lower storage costs. Their Time Travel retention period is capped at 1 day (DATA_RETENTION_TIME_IN_DAYS can be set to 0 or 1). In contrast, standard…

Storage and Data Protection

Question

Options

AO days
B1 day
C7 days
D90 days

How the community answered

(22 responses)

A
9% (2)
B
86% (19)
C
5% (1)

Explanation

Transient tables in Snowflake are designed for temporary, non-critical data and intentionally have reduced durability features to lower storage costs. Their Time Travel retention period is capped at 1 day (DATA_RETENTION_TIME_IN_DAYS can be set to 0 or 1). In contrast, standard permanent tables support up to 90 days of Time Travel (on Enterprise edition and above). Transient tables also have no Fail-safe period, unlike permanent tables which have a 7-day Fail-safe window after Time Travel expires.

Topics

#Time Travel#Transient Tables#Data Retention

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice