SnowPro Core Certification — Question 871

What do temporary and transient tables have in common in Snowflake? (Choose two.)

Answer options

• A. Both tables have no Fail-safe period.
• B. Both tables have data retention period maximums of one day.
• C. Both tables are visible only to a single user session.
• D. For both tables, the retention period ends when the tables are dropped.
• E. For both tables, the retention period does not end when the session ends.

Correct answer: A, B

Explanation

The correct answers, A and B, highlight that both temporary and transient tables in Snowflake lack a Fail-safe period and have a maximum data retention period of one day. Options C and E are incorrect because both types of tables can be visible to multiple sessions under certain circumstances, and option D is incorrect as the retention period for transient tables does not necessarily end when they are dropped.