Answer-first summary for fast verification
Answer: Transient tables persist until they are explicitly dropped., Transient tables have Time Travel retention periods of 0 or 1 day.
Based on Snowflake documentation and the community discussion consensus (with CE having 80% support and multiple upvoted comments), the correct characteristics of transient tables are: C) Transient tables persist until they are explicitly dropped, and E) Transient tables have Time Travel retention periods of 0 or 1 day. Option C is correct because transient tables are persistent until manually dropped, unlike temporary tables. Option E is correct because transient tables have limited Time Travel retention (0 or 1 day) to reduce storage costs. Option A is incorrect because transient tables do NOT have Fail-safe (0 days). Option B is incorrect because while transient tables can be cloned, the clone inherits the same transient type, not automatically becoming permanent. Option D is incorrect because transient tables cannot be altered to become permanent; a new permanent table must be created.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which two statements describe characteristics of transient tables in Snowflake?
A
Transient tables have a Fail-safe period of 7 days.
B
Transient tables can be cloned to permanent tables.
C
Transient tables persist until they are explicitly dropped.
D
Transient tables can be altered to make them permanent tables.
E
Transient tables have Time Travel retention periods of 0 or 1 day.
No comments yet.