Learn about Snowflake’s best practices for storing data that can be recreated outside of the platform. Discover why Transient tables are the preferred choice for this scenario.
Table of Contents
Question
According to best practices, which table type should be used if the data can be recreated outside of Snowflake?
A. Permanent table
B. Temporary table
C. Transient table
D. Volatile table
Answer
C. Transient table
Explanation
The best practice for storing data that can be recreated outside of Snowflake is to use a Transient table. Transient tables in Snowflake are similar to permanent tables, the only difference being that they do not maintain any undrop or Time Travel history once the data is deleted. This makes them ideal for storing data that can be easily recreated, as it allows for efficient use of storage without the need to maintain historical data.
Snowflake SnowPro Core certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Snowflake SnowPro Core exam and earn Snowflake SnowPro Core certification.