Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 722

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

    Correct Answer: D

    Transient tables in Snowflake help reduce costs for ETL workflows. They do not incur fail-safe storage costs because they do not have the fail-safe period that permanent tables have. These tables are designed for data that only needs to be retained for a short period of time, reducing the overall storage costs.

Discussion
blitzzzzOption: C

C since temporary tables are only available for the duration of a session, and they are not stored in Snowflake's permanent storage. This means that they do not incur any storage costs.

MultiCloudIronManOption: C

Correct