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?
A . Time Travel – 1 day. Fail-safe – 1 day
B. Time Travel – 0 days. Fail-safe – 1 day
C. Time Travel – 1 day. Fail-safe – 0 days
D. Transient tables are retained in neither Fail-safe nor Time Travel

View Answer

Answer: D

Explanation:

Transient tables in Snowflake do not have a Time Travel retention period or a Fail-safe retention period. These tables are designed for temporary storage and intermediate processing, and as such, they do not maintain historical data versions or offer data protection through Fail-safe. Once the data is deleted from a transient table, it cannot be recovered using Time Travel or Fail-safe features.