Which Snowflake object does not consume any storage costs?

The correct answer is C. Temporary table. Temporary tables do not consume any storage costs in Snowflake because they only exist for the duration of the session that created them and are automatically dropped when the session ends, thus incurring no long-term storage charges.

Storage and Data Protection

Question

Options

ASecure view
BMaterialized view
CTemporary table
DTransient table

How the community answered

(43 responses)

A
2% (1)
B
5% (2)
C
93% (40)

Explanation

Temporary tables do not consume any storage costs in Snowflake because they only exist for the duration of the session that created them and are automatically dropped when the session ends, thus incurring no long-term storage charges.

Topics

#Temporary tables#Storage costs#Table types#Snowflake objects

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice