Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)

Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)
A . They can include ORDER BY clauses.
B . They cannot include nested subqueries.
C . They can include context functions, such as CURRENT_TIME ().
D . They can support MIN and MAX aggregates.
E . They can support inner joins, but not outer joins.

View Answer

Answer: B, D

Explanation:

According to the Snowflake documentation, materialized views have some limitations on the query specification that defines them. One of these limitations is that they cannot include nested subqueries, such as subqueries in the FROM clause or scalar subqueries in the SELECT list. Another limitation is that they cannot include ORDER BY clauses, context functions (such as CURRENT_TIME()), or outer joins. However, materialized views can support MIN and MAX aggregates, as well as other aggregate functions, such as SUM, COUNT, and AVG.

Reference: Limitations on Creating Materialized Views | Snowflake Documentation Working with Materialized Views | Snowflake Documentation