Answer-first summary for fast verification
Answer: Both tables have no Fail-safe period., Both tables have data retention period maximums of one day.
The question asks for two characteristics shared by both temporary and transient tables in Snowflake. According to Snowflake documentation and the community consensus (100% agreement on AB with upvoted comments referencing official docs), both table types have no Fail-safe period (A) and both have a maximum data retention period of one day (B). Option C is incorrect as temporary tables are session-scoped while transient tables are not. Option D is incorrect because retention periods differ - temporary tables are dropped when the session ends, while transient tables persist until explicitly dropped. Option E is incorrect as temporary tables do end their retention when the session ends.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which two characteristics are shared by both temporary and transient tables in Snowflake?
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.
No comments yet.