You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required.

You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required.

What type of table you will use in this case to optimize cost
A . TRANSIENT
B. TEMPORARY
C. PERMANENT

View Answer

Answer: A

Explanation:

Let us see why?

Storage fees are incurred for maintaining historical data during both the Time Travel and Fail-safe periods.The fees are calculated for each 24-hour period (i.e. 1 day) from the time the data changed. The number of days historical data is maintained is based on the table type and the Time Travel retention period for the table.

If you create a permanent table, it will have by default fail safe period of 7 days. That means it needs to allocate space to keep historical data for 7 days. Transient table, on the other hand, does not have fail safe period. Hence using transient table will be the most optimal approach from a cost perspective. Temporary table cannot be used here because temporary tables expire as soon as the session ends.