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

Which Snowflake table types are used to manage costs for short-lived tables? (Choose two.)

    Correct Answer: D, E

    To manage costs for short-lived tables in Snowflake, Temporary tables and Transient tables are used. Temporary tables are designed for data that is short-lived and do not survive beyond a single session. Transient tables are also suitable for temporary data storage but differ from temporary tables as they can persist across sessions and have reduced storage costs because they do not have fail-safe. These characteristics make both types optimal for managing costs associated with short-lived data.

Discussion
HeetecOptions: DE

DE correct - https://docs.snowflake.com/en/user-guide/tables-storage-considerations