Snowflake COF-C02 Exam - 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

Dustin

5 months ago

I thought transient tables were free for storage?

upvoted 0 times

...

Gilma

5 months ago

I think it's A and C!

upvoted 0 times

...

Catherin

6 months ago

Materialized views definitely incur both charges.

upvoted 0 times

...

Melda

6 months ago

Totally agree with A, but not sure about C.

upvoted 0 times

...

Lore

6 months ago

Wait, does a secure view really cost both?

upvoted 0 times

...

Regenia

6 months ago

I’m leaning towards materialized views and clustered tables, but I need to double-check if clustered tables actually incur compute charges.

upvoted 0 times

...

Barb

6 months ago

I feel like secure views are just for security and don’t really incur those charges, but materialized views are definitely a safe bet.

upvoted 0 times

...

Carmen

7 months ago

I remember practicing a question about storage costs, and I think transient tables might not incur compute charges, but I could be wrong.

upvoted 0 times

...

Rosann

7 months ago

I think materialized views definitely incur both storage and compute charges, but I'm not sure about the second option.

upvoted 0 times

...

Darci

7 months ago

For this type of question, I usually try to eliminate the options that are clearly not correct first. Then I can focus on the more ambiguous ones and make my best guess.

upvoted 0 times

...

Maira

7 months ago

I'm a bit confused on this one. I know materialized views have storage and compute costs, but I'm not sure about the other options. Guess I'll have to think it through.

upvoted 0 times

...

Melvin

7 months ago

I'm pretty confident that materialized views and secure views are the two that will incur both storage and compute charges. The others seem more straightforward.

upvoted 0 times

...

Arlyne

8 months ago

Okay, let's see. Materialized views and transient tables seem like they could be the right answers, but I'm not totally sure.

upvoted 0 times

...

Asha

8 months ago

Hmm, this is a tricky one. I'll need to think carefully about which Snowflake objects incur both storage and compute charges.

upvoted 0 times

...

Chaya

1 year ago

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

upvoted 0 times

...

Cherry

1 year 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

Dianne

11 months ago

Yeah, they may look pretty, but they sure do love to eat up our budget.

upvoted 0 times

...

Catina

11 months ago

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

upvoted 0 times

...

Amie

12 months ago

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

upvoted 0 times

...

Celestina

1 year 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

12 months 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

12 months ago

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

upvoted 0 times

...

Blossom

12 months 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 year ago

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

upvoted 0 times

...

Leonor

1 year ago

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

upvoted 0 times

...

Keshia

1 year ago

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

upvoted 0 times

...

Queen

1 year 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

12 months 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

12 months ago

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

upvoted 0 times

...

Glenna

12 months ago

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

upvoted 0 times

...

Jackie

1 year ago

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

upvoted 0 times

Weldon

12 months ago

It's a trade-off between performance and cost

upvoted 0 times

...

Lindsay

12 months ago

I always try to avoid using materialized views for that reason

upvoted 0 times

...

Rickie

12 months ago

Yep, those two will definitely cost you

upvoted 0 times

...

Laurena

1 year ago

Materialized view and transient table

upvoted 0 times

...

Lamonica

1 year ago

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

upvoted 0 times

...

Nadine

1 year ago

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

upvoted 0 times

...

Lanie

1 year ago

Yes, those two are the culprits for extra charges.

upvoted 0 times

...

Winifred

1 year ago

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

upvoted 0 times

...