SnowPro Core Certification — Question 877

Why would a Snowflake user choose to use a transient table?

Answer options

• 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

Correct answer: D

Explanation

The correct answer is D because transient tables are designed to hold temporary data that needs to be accessible beyond the current session, but without the durability of permanent tables. Options A and C are incorrect as they refer to long-term or permanent storage, which is not the purpose of transient tables. Option B is misleading, as transient tables are not primarily for storing large data files but rather for temporary data management.