SnowPro Core Certification — Question 678

What are characteristics of transient tables in Snowflake? (Choose two.)

Answer options

• A. Transient tables have a Fail-safe period of 7 days.
• B. Transient tables can be cloned to permanent tables.
• C. Transient tables persist until they are explicitly dropped.
• D. Transient tables can be altered to make them permanent tables.
• E. Transient tables have Time Travel retention periods of 0 or 1 day.

Correct answer: C, E

Explanation

The correct answers are C and E because transient tables in Snowflake remain available until they are explicitly deleted, and they have a Time Travel retention period of either 0 or 1 day. Options A and D are incorrect as transient tables do not have a Fail-safe period and cannot be converted to permanent tables.