SnowPro Core Certification — Question 1135

Which Snowflake storage object can be used to store data beyond a single session and will not incur Fail-safe costs?

Answer options

• A. Permanent table
• B. External table
• C. Temporary table
• D. Transient table

Correct answer: D

Explanation

The correct answer is D, Transient table, as it allows data to be stored across sessions without incurring Fail-safe costs. Permanent tables will incur Fail-safe costs, while Temporary tables only last for a single session and External tables are used for data stored outside of Snowflake.