A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.
What table type should be used?
A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.
What table type should be used?
To minimize costs for storing transitory data that does not need to be protected against failures and can be reconstructed outside of Snowflake, a Transient table should be used. Transient tables are designed for short-term data storage, providing cost savings by not incurring additional charges for fail-safes and minimizing the time travel period.
transient tables provide a good option for managing the cost of very large tables used to store transitory data; recommend using transient tables only for data that does not need to be protected against failures or data that can be reconstructed outside of Snowflake.
https://docs.snowflake.com/en/user-guide/tables-temp-transient#transient-tables
B is Correct. Transient tables are best suited in scenarios where the data in your table is not critical and can be recovered from external means if required. Also, they have no fail-safe period, and Time travel is also only 1 day (which can be set to 0 also).
Transitory data -] transient
Correct
I think D iscorrect