SnowPro Advanced: Architect — Question 10

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

Answer options

• 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.

Correct answer: B, D

Explanation

Option B is correct because materialized views in Snowflake cannot include nested subqueries, which limits their complexity. Option D is also correct as these views can support MIN and MAX aggregates, enabling summary calculations. The other options are incorrect; for instance, materialized views can include ORDER BY clauses, context functions, and support both inner and outer joins.