Page 1 of 1

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

Posted: Thu Apr 06, 2023 1:25 pm
by answerhappygod
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.