How long is the Fail-safe period for temporary and transient tables?
A.
There is no Fail-safe period for these tables.
B.
1 day
C.
7 days
D.
31 days
E.
90 days
The Answer Is:
A
This question includes an explanation.
Explanation:
Temporary and transient tables in Snowflake do not have a Fail-safe period. Once the session ends or the tables are dropped, the data is purged and not recoverable1.