Which Snowflake table type persists until it is explicitly dropped. is available for all users with relevant privileges (across sessions). and has no Fail-safe period?

The correct answer is D. Transient. Transient tables persist beyond session boundaries (unlike Temporary tables, which are session-scoped) and are available to any user with the appropriate privileges. However, they have a Time Travel period of 0 or 1 day and, critically, have NO Fail-safe period (Fail-safe = 0…

Storage and Data Protection

Question

Options

AExternal
BPermanent
CTemporary
DTransient

How the community answered

(51 responses)

A
6% (3)
B
2% (1)
C
4% (2)
D
88% (45)

Explanation

Transient tables persist beyond session boundaries (unlike Temporary tables, which are session-scoped) and are available to any user with the appropriate privileges. However, they have a Time Travel period of 0 or 1 day and, critically, have NO Fail-safe period (Fail-safe = 0 days). Permanent tables have both Time Travel and a 7-day Fail-safe period, making them more expensive to store. Temporary tables exist only within a single session. External tables reference data in external cloud storage and have no Fail-safe, but they don't 'store' data internally. Transient tables are designed for data that does not need the extra protection and cost of Fail-safe.

Topics

#Snowflake table types#Transient tables#Data persistence#Fail-safe

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice