Snowflake Exam COF-C02 Topic 8 Question 4 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 4
Topic #: 8

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 Kimberlie at Dec 06, 2022, 08:24 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!