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