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: B

Explanation:

B. TEMPORARY

For the given use case, where new data comes in every day and the old data is no longer required, a temporary table would be a cost-effective option. Temporary tables in Snowflake are session-specific and are automatically dropped at the end of the session. If the business team’s visualization needs in Tableau are only for the duration of a session or a day, and there is no need to persist the old data, then temporary tables can be used to store the data for that day’s session. This approach ensures that you’re not incurring storage costs for data that is no longer needed.

If, however, the data needs to persist beyond a single session but still does not require long-term storage, a transient table could be considered. Transient tables are similar to permanent tables but have lower data retention guarantees and incur lower storage costs. They are suitable for scenarios where data is needed for more than just the duration of a session but does not need the durability and retention of a permanent table.

Permanent tables are meant for data that needs to persist indefinitely and be highly durable, with full data retention features of Snowflake, which seems more than necessary for the use case described.