SnowPro Core Certification — Question 466

A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.

What table type should be used?

Answer options

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

Correct answer: B

Explanation

The Transient table type is ideal for storing temporary data without incurring the costs associated with failure protection, making it the best choice here. Permanent tables, on the other hand, provide durability and protection, which isn't necessary in this case. Temporary tables are session-based and not suitable for larger, persistent datasets, while External tables are used for data stored outside of Snowflake and are not relevant for this scenario.