SnowPro Core Certification — Question 1024

According to best practices, which table type should be used if the data can be recreated outside of Snowflake?

Answer options

• A. Permanent table
• B. Temporary table
• C. Transient table
• D. Volatile table

Correct answer: C

Explanation

The correct choice is C, Transient table, as it is designed for data that does not require long-term retention and can be recreated. A Permanent table is not suitable because it is meant for data that needs to be preserved indefinitely, while a Temporary table is session-specific and will be lost at the end of the session. Volatile table is not a standard Snowflake table type.