What is the maximum Time Travel retention period for a temporary Snowflake table?

The correct answer is B. 1 day. Temporary tables in Snowflake have a maximum Time Travel retention period of 1 day (configurable to 0 or 1). This restriction also applies to transient tables. The reasoning is that temporary tables only exist for the duration of the session and are designed for short-lived…

Storage and Data Protection

Question

Options

A90 days
B1 day
C7 days
D45 days

How the community answered

(30 responses)

A
7% (2)
B
90% (27)
D
3% (1)

Explanation

Temporary tables in Snowflake have a maximum Time Travel retention period of 1 day (configurable to 0 or 1). This restriction also applies to transient tables. The reasoning is that temporary tables only exist for the duration of the session and are designed for short-lived use, so extended retention is unnecessary. Permanent tables in Enterprise Edition can have up to 90 days of Time Travel. The 7-day and 45-day options do not apply to any standard Snowflake table type's Time Travel configuration.

Topics

#Time Travel#Temporary Tables#Data Retention#Table Limits

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice