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