SnowPro Core Recertification — Question 8

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: D

Explanation

The correct choice is D, External, as it allows for cost-effective storage of data that does not need to be maintained within Snowflake. Options A (Permanent) and B (Transient) incur additional costs by retaining data longer than necessary, while C (Temporary) is not suitable since it only exists within a session.