The is the minimum Fail-safe retention time period for transient tables?
The is the minimum Fail-safe retention time period for transient tables?
A transient table in Snowflake does not have a Fail-safe retention period. Unlike permanent tables, which have a fail-safe period, transient tables are designed without this feature to facilitate quick deletion and avoid unnecessary storage costs.
https://docs.snowflake.com/en/user-guide/tables-temp-transient "Transient tables are similar to permanent tables with the key difference that they do not have a Fail-safe period."
0 days for both transient and temporary tables
temporary is 1 day
for Time Travel
D. 0 Days
Correct Answer:D
D. 0 days
Correct
Table Type Time Travel Retention Period (Days) Fail-safe Period (Days) Permanent 0 or 1 (for Snowflake Standard Edition) 7 0 to 90 (for Snowflake Enterprise Edition) 7 Transient 0 or 1 0 Temporary 0 or 1 0
No fail safe period for Transient table
7days .and it is non configurable .
7days .and it is non configurable .