Snowflake Exam COF-R02 Topic 6 Question 42 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 42
Topic #: 6

[All COF-R02 Questions]

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.

Show Suggested Answer

Suggested Answer: C, E

by Sang at Sep 12, 2024, 11:17 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Felix

15 days ago

But what about when the base table gets updated frequently? Wouldn't that also be a good reason to create a materialized view?

upvoted 0 times

...

Jovita

16 days ago

I agree with Karan. E and B are the key factors to consider when creating a materialized view. Optimized queries and low cost don't justify a materialized view.

upvoted 0 times

...

Kimberlie

21 days ago

I agree with Louisa. It makes sense to create a materialized view in that scenario to improve performance.

upvoted 0 times

...

Louisa

26 days ago

I think a materialized view should be created when the query consumes many compute resources every time it runs.

upvoted 0 times

...

Karan

1 months ago

I think E and B are the right answers. Materialized views are useful when the query results don't change often and the query is resource-intensive.

upvoted 0 times

Ashleigh

16 days ago

Yes, that's correct. It helps with optimizing performance.

upvoted 0 times

...

Ashleigh

1 months ago

I agree, materialized views are great for reducing compute resources.

upvoted 0 times

...