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

exams ARA-C01 V3 ARA-C01 exam 0 Comments

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.

Answer: B,D