Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

Snowflake Exam COF-C02 Topic 7 Question 54 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 54
Topic #: 7

[All COF-C02 Questions]

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

AMaterialized view

BSequence

CSecure view

DTransient table

EClustered table

Show Suggested Answer

Suggested Answer: A, D

In Snowflake, both materialized views and transient tables will incur storage charges because they store data. They will also incur compute charges when queries are run against them, as compute resources are used to process the queries. References: [COF-C02] SnowPro Core Certification Exam Study Guide

by Mirta at Apr 05, 2025, 05:40 PM

Limited Time Offer

25%

Off

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Chaya

7 days ago

I'm going with the materialized view and the sequence. Sequences? More like 'pay-quences', am I right?

upvoted 0 times

...

Cherry

9 days ago

The materialized view and the transient table, no doubt. And people say snowflakes are beautiful - they're really just money-hungry monsters in disguise.

upvoted 0 times

...

Celestina

19 days ago

Gotta be the materialized view and the secure view. Why do they always try to trick us with these questions?

upvoted 0 times

Blossom

1 days ago

I think you're right, materialized view and secure view are the ones that will incur both storage and cloud compute charges.

upvoted 0 times

...

...

Phung

1 months ago

I'm not sure about Secure view. Does it also incur charges?

upvoted 0 times

...

Leonor

1 months ago

I agree with Keshia. Materialized view stores data and Clustered table requires compute resources.

upvoted 0 times

...

Keshia

1 months ago

I think both Materialized view and Clustered table will incur charges.

upvoted 0 times

...

Queen

1 months ago

Hmm, I'm pretty sure it's the materialized view and the clustered table. Cloud vendors are always looking for ways to milk us dry.

upvoted 0 times

Glenna

1 days ago

I think you're right, materialized views and clustered tables definitely incur both storage and compute charges.

upvoted 0 times

...

...

Jackie

1 months ago

Easy peasy! Materialized views and transient tables, of course. The cloud loves to charge us for those.

upvoted 0 times

Rickie

1 days ago

Yep, those two will definitely cost you

upvoted 0 times

...

Laurena

8 days ago

Materialized view and transient table

upvoted 0 times

...

Lamonica

9 days ago

It's a good reminder to be mindful of those when working with snowflake objects.

upvoted 0 times

...

Nadine

18 days ago

I always have to keep an eye on my usage with materialized views and transient tables.

upvoted 0 times

...

Lanie

19 days ago

Yes, those two are the culprits for extra charges.

upvoted 0 times

...

Winifred

21 days ago

Materialized view and transient table will incur both storage and cloud compute charges.

upvoted 0 times

...

...