Snowflake SnowPro Core

Ultimate access to all questions.

Under which of the following circumstances should a materialized view be created? (Choose two.)

Exam-Like

A

There is minimal cost associated with running the query.

2.4%

B

The query consumes many compute resources every time it runs.

28.6%

Loading comments...

C

The base table gets updated frequently.

11.9%

D

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

7.1%

E

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

50.0%

Powered ByGPT-5.2