How long is the Fail-safe period for temporary and transient tables?
How long is the Fail-safe period for temporary and transient tables?
The Fail-safe period is a Snowflake feature that provides a mechanism for recovering data that has been deleted and purged from tables. However, the Fail-safe period does not apply to temporary and transient tables. Temporary tables are automatically dropped at the end of the session in which they were created, and transient tables are designed to have a more relaxed approach to data recovery, not offering the Fail-safe protection.
no fail safe for transient / temporary tables
Correct
There was a similar question on the exam when I took it july 20th 2023
'A' There is Zero (0) day Fail Safe period for temp and transient table
All answers are incorrect. There is Zero (0) day Fail Safe period for temp and transient tables.
A. There is no Fail-safe period for these tables.
There is no fail safe period for Temp and transient tables