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

22 days ago

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

upvoted 0 times

...

Cherry

24 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

Catina

3 days ago

I know, it's crazy how much those snowflakes can cost us.

upvoted 0 times

...

Amie

11 days ago

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

upvoted 0 times

...

Celestina

1 months ago

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

upvoted 0 times

Cathern

8 days ago

It's important to pay attention to the details when it comes to cloud services. Good job on picking the right options.

upvoted 0 times

...

Armanda

15 days ago

Yeah, they always try to make it tricky with these questions. But we got it right!

upvoted 0 times

...

Blossom

16 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

2 months ago

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

upvoted 0 times

...

Leonor

2 months ago

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

upvoted 0 times

...

Keshia

2 months ago

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

upvoted 0 times

...

Queen

2 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

Claudia

5 days ago

It's just the way the business works, unfortunately. Gotta be careful with what we use to avoid unnecessary charges.

upvoted 0 times

...

Sharika

7 days ago

Yeah, cloud vendors always find ways to make us pay for every little thing.

upvoted 0 times

...

Glenna

16 days ago

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

upvoted 0 times

...

Jackie

2 months ago

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

upvoted 0 times

Weldon

9 days ago

It's a trade-off between performance and cost

upvoted 0 times

...

Lindsay

14 days ago

I always try to avoid using materialized views for that reason

upvoted 0 times

...

Rickie

16 days ago

Yep, those two will definitely cost you

upvoted 0 times

...

Laurena

23 days ago

Materialized view and transient table

upvoted 0 times

...

Lamonica

24 days ago

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

upvoted 0 times

...

Nadine

1 months ago

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

upvoted 0 times

...

Lanie

1 months ago

Yes, those two are the culprits for extra charges.

upvoted 0 times

...

Winifred

1 months ago

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

upvoted 0 times

...