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

- Free Preparation Discussions

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.)

Show Suggested Answer Hide Answer
Suggested Answer: C, E

Contribute your Thoughts:

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
...
...

Save Cancel