COF-C02 · Question #679
What is the minimum Snowflake edition required to create a materialized view?
The correct answer is B. Enterprise Edition. Materialized views are a feature exclusive to Snowflake Enterprise Edition and above (Business Critical, Virtual Private Snowflake). Standard Edition does not support them. Materialized views pre-compute and store the results of a query, allowing faster access to complex…
Question
What is the minimum Snowflake edition required to create a materialized view?
Options
- AStandard Edition
- BEnterprise Edition
- CBusiness Critical Edition
- DVirtual Private Snowflake Edition
How the community answered
(43 responses)- A5% (2)
- B91% (39)
- C2% (1)
- D2% (1)
Explanation
Materialized views are a feature exclusive to Snowflake Enterprise Edition and above (Business Critical, Virtual Private Snowflake). Standard Edition does not support them. Materialized views pre-compute and store the results of a query, allowing faster access to complex aggregations and joins. Because they consume additional storage and background maintenance resources (Snowflake automatically keeps them synchronized with the base table), they are gated to higher-tier editions. This is a commonly tested edition-feature boundary on Snowflake certification exams.
Topics
Community Discussion
No community discussion yet for this question.