SnowPro Core Certification — Question 725

The use of which Snowflake table type will reduce costs when working with ETL workflows?

Answer options

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

Correct answer: C

Explanation

Temporary tables in Snowflake do not incur storage costs after they are dropped, making them ideal for ETL workflows where data is only needed temporarily. In contrast, Permanent and Transient tables incur ongoing storage costs, while External tables are used for data stored outside of Snowflake, which may not be relevant for ETL operations.