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

The correct answer is A. TRANSIENT. A TRANSIENT table is the most cost-effective choice when data is replaced daily and historical recovery is not needed. Unlike PERMANENT tables, transient tables have no Fail-safe period (permanent tables have 7 days of Fail-safe storage on top of Time Travel), significantly reduc

Cost Optimization

Question

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

Options

ATRANSIENT
BTEMPORARY
CPERMANENT

How the community answered

(43 responses)

A
81% (35)
B
7% (3)
C
12% (5)

Explanation

A TRANSIENT table is the most cost-effective choice when data is replaced daily and historical recovery is not needed. Unlike PERMANENT tables, transient tables have no Fail-safe period (permanent tables have 7 days of Fail-safe storage on top of Time Travel), significantly reducing storage costs. Unlike TEMPORARY tables (option B), transient tables persist across sessions, so the data remains available for Tableau dashboards between connections. Since the old data is discarded daily and no long-term recovery is required, paying for Fail-safe storage on a permanent table would be wasteful. Transient tables strike the balance: session-persistent for BI tools, but low-cost due to no Fail-safe overhead.

Topics

#Snowflake table types#Cost optimization#Data retention#Transient tables

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice