Snowflake
COF-R02 · Question #246
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
The correct answer is D. Whether the materialized view has a cluster key defined E. How often the materialized view is queried. See the full explanation below for the reasoning.
Question
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
Options
- AWhether or not it is also a secure view
- BHow often the underlying base table is queried
- CHow often the base table changes
- DWhether the materialized view has a cluster key defined
- EHow often the materialized view is queried
How the community answered
(52 responses)- A17% (9)
- B2% (1)
- C6% (3)
- D75% (39)
Community Discussion
No community discussion yet for this question.