COF-C02 · Question #20
What are the default Time Travel and Fail-safe retention periods for transient tables?
The correct answer is C. Time Travel - 1 day. Fail-safe - 0 days. Transient tables in Snowflake have a default Time Travel retention period of 1 day, which allows users to access historical data within the last 24 hours. However, transient tables do not have a Fail-safe period. Fail-safe is an additional layer of data protection that retains…
Question
What are the default Time Travel and Fail-safe retention periods for transient tables?
Options
- ATime Travel - 1 day. Fail-safe - 1 day
- BTime Travel - 0 days. Fail-safe - 1 day
- CTime Travel - 1 day. Fail-safe - 0 days
- DTransient tables are retained in neither Fail-safe nor Time Travel
How the community answered
(26 responses)- A4% (1)
- B4% (1)
- C92% (24)
Explanation
Transient tables in Snowflake have a default Time Travel retention period of 1 day, which allows users to access historical data within the last 24 hours. However, transient tables do not have a Fail-safe period. Fail-safe is an additional layer of data protection that retains data beyond the Time Travel period for recovery purposes in case of extreme data loss. Since transient tables are designed for temporary or intermediate workloads with no requirement for long-term durability, they do not include a Fail-safe period by default.
Topics
Community Discussion
No community discussion yet for this question.