Discuss Snowflake COF-C02 Exam Topic 8 Question 4

A materialized view should be created when which of the following occurs? (Choose two.)

AThere is minimal cost associated with running the query.

BThe query consumes many compute resources every time it runs.

CThe base table gets updated frequently.

DThe query is highly optimized and does not consume many compute resources.

EThe results of the query do not change often and are used frequently.

Suggested Answer: C, E

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

13 comments · newest first

Remedios 11 months ago

C is a no-go, frequent updates can mess things up!

Olene 11 months ago

Wait, I thought materialized views were only for static data?

Tatum 12 months ago

A materialized view is a must when queries are resource-heavy!

Gail 12 months ago

I disagree with E, it can still be useful even if results change occasionally.

Ashlee 12 months ago

Definitely B and E! Makes total sense.

Pauline 1 year ago

I have a vague memory that A and D are not the best choices, but I can't recall exactly why. I think they relate to cost and optimization, which don't really justify a materialized view.

Shawn 1 year ago

I practiced a similar question, and I feel like C is definitely not right because frequent updates to the base table would make a materialized view less effective.

Vinnie 1 year ago

I’m not entirely sure, but I think E could also be correct since materialized views are good for stable data that’s queried often.

Ilene 1 year ago

I remember discussing how materialized views are useful when queries are resource-intensive, so I think B might be one of the answers.

Linn 1 year ago

Okay, I remember learning that proteins are broken down into their basic building blocks, which are amino acids. So the end product of proteins has to be amino acids. I'll select option A.

Gertude 1 year ago

Documented and repeatable testing processes are key for mobile apps, which have to work across many devices and platforms.

Adelaide 1 year ago

Okay, I think I've got this. The key is to use the SVAs as a starting point, but then consider your specific requirements and design principles to come to the best decision. I'll select that option.

Alison 1 year ago

Okay, I think I've got it. The evergreen clause is there to ensure Dr. Chau provides timely healthcare services to Fiesta members, as described in option D. That makes the most sense to me.

Snowflake COF-C02 Exam - Topic 8 Question 4 Discussion