What are the default Time Travel and Fail-safe retention periods for transient tables?
What are the default Time Travel and Fail-safe retention periods for transient tables?
The default Time Travel retention period for transient tables is 1 day, and they have no Fail-safe retention period. While transient tables support Time Travel, they do not have a Fail-safe period, which is a feature primarily for permanent tables to ensure data recovery. Therefore, the correct answer is that transient tables have a Time Travel period of 1 day and a Fail-safe period of 0 days.
Transient tables can have a Time Travel retention period of either 0 or 1 day. Temporary tables can also have a Time Travel retention period of 0 or 1 day; however, this retention period ends as soon as the table is dropped or the session in which the table was created ends. Transient and temporary tables have no Fail-safe period.
it should be C
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#comparison-of-table-types
C is correct
correct