Which Snowflow object does not consume and storage costs?

The correct answer is C. Temporary table. Temporary tables in Snowflake do not consume storage costs. They are designed for transient data that is needed only for the duration of a session. Data stored in temporary tables is held in the virtual warehouse's cache and does not persist beyond the session's lifetime…

Storage and Data Protection

Question

Options

ASecure view
BMaterialized view
CTemporary table
DTransient table

How the community answered

(47 responses)

A
4% (2)
B
9% (4)
C
72% (34)
D
15% (7)

Explanation

Temporary tables in Snowflake do not consume storage costs. They are designed for transient data that is needed only for the duration of a session. Data stored in temporary tables is held in the virtual warehouse's cache and does not persist beyond the session's lifetime, thereby not incurring any storage charges.

Topics

#Storage Costs#Temporary Tables#Data Retention#Snowflake Objects

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice