Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

The correct answer is A. Materialized view D. Transient table. Materialized views (A) incur storage charges because Snowflake physically stores the pre-computed query results, and they also incur cloud services compute charges for the automatic background maintenance process that keeps the materialized results synchronized with the base…

Storage and Data Protection

Question

Options

AMaterialized view
BSequence
CSecure view
DTransient table
EClustered table

How the community answered

(55 responses)

A
91% (50)
B
5% (3)
C
2% (1)
E
2% (1)

Explanation

Materialized views (A) incur storage charges because Snowflake physically stores the pre-computed query results, and they also incur cloud services compute charges for the automatic background maintenance process that keeps the materialized results synchronized with the base table. Transient tables (D) incur storage charges for the data they hold (though with no Fail-Safe period), and they use virtual warehouse compute resources for DML operations performed against them. Sequences (B) generate sequential numbers and have negligible storage with no inherent compute cost. Secure views (C) are virtual - they store no data and only use compute when queried. The question targets objects with inherent, ongoing dual charges by their nature.

Topics

#Storage Costs#Compute Costs#Materialized Views#Transient Tables

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice