Snowflake
COF-R02 · Question #315
A materialized view should be created when which of the following occurs? (Choose two.)
The correct answer is C. The base table gets updated frequently. E. The results of the query do not change often and are used frequently. See the full explanation below for the reasoning.
Question
A materialized view should be created when which of the following occurs? (Choose two.)
Options
- 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.
How the community answered
(28 responses)- A7% (2)
- B4% (1)
- C75% (21)
- D14% (4)
Community Discussion
No community discussion yet for this question.