Answer-first summary for fast verification
Answer: To store transitory data that needs to be maintained beyond the session
Transient tables in Snowflake are designed for storing transitory data that needs to persist beyond a session but doesn't require the same level of data protection and time travel features as permanent tables. Option D correctly identifies this use case. Option A is incorrect because long-term analysis typically requires permanent tables with full data protection. Option B is unsuitable as frequently used large data files are better served by permanent tables. Option C is incorrect because ongoing ELT processes typically use permanent tables, not transient tables. The community discussion shows unanimous consensus (100%) for option D, with the top-voted comment specifically citing Snowflake documentation that transient tables are for 'transitory data that needs to be maintained beyond each session.'
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Why would a Snowflake user choose to create a transient table?
A
To store data for long-term analysis
B
To store large data files that are used frequently
C
To create a permanent table for ongoing use in ELT
D
To store transitory data that needs to be maintained beyond the session