What do temporary and transient tables have m common in Snowflake? (Select TWO).

The correct answer is A. Both tables have no Fail-safe period. D. For both tables the retention period ends when the tables are dropped. Temporary and transient tables in Snowflake share several characteristics, notably, neither table type has a Fail-safe period. Fail-safe is a feature that provides additional data protection beyond the Time Travel period. However, this feature does not apply to temporary or…

Storage and Data Protection

Question

Options

ABoth tables have no Fail-safe period.
BBoth tables have data retention period maximums of one day.
CBoth tables are visible only to a single user session.
DFor both tables the retention period ends when the tables are dropped.
EFor both tables, the retention period does not end when the session ends

How the community answered

(34 responses)

A
88% (30)
B
3% (1)
C
6% (2)
E
3% (1)

Explanation

Temporary and transient tables in Snowflake share several characteristics, notably, neither table type has a Fail-safe period. Fail-safe is a feature that provides additional data protection beyond the Time Travel period. However, this feature does not apply to temporary or transient tables. Additionally, for both types of tables, the data retention period effectively ends when the tables are dropped. This means that once these tables are deleted, their data is not recoverable, distinguishing them from permanent tables, which benefit from Snowflake's Time Travel and Fail-

Topics

#Temporary Tables#Transient Tables#Data Retention#Fail-safe

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice