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

exams ARA-C01 V2 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: C,D