Explanation:
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.
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.