SnowPro Core Certification — Question 671

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 since they are ephemeral and only exist within the session they were created in. In contrast, Permanent and Transient tables incur storage costs, and External tables are typically used for data stored outside of Snowflake, which may not be cost-effective for ETL workflows.