What is the minimum Snowflake edition required to create a materialized view?

What is the minimum Snowflake edition required to create a materialized view?
A . Standard Edition
B . Enterprise Edition
C . Business Critical Edition
D . Virtual Private Snowflake Edition

View Answer

Answer: B

Explanation:

Materialized views in Snowflake are a feature that allows for the pre-computation and storage of query results for faster query performance. This feature is available starting from the Enterprise Edition of Snowflake. It is not available in the Standard Edition, and while it is also available in higher editions like Business Critical and Virtual Private Snowflake, the Enterprise Edition is the minimum requirement.

Reference: Snowflake Documentation on CREATE MATERIALIZED VIEW1. Snowflake Documentation on Working with Materialized Views

https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.