ARA-C01 · Question #145
Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)
The correct answer is B. They cannot include nested subqueries. D. They can support MIN and MAX aggregates. According to the Snowflake documentation, materialized views have some limitations on the query specification that defines them. One of these limitations is that they cannot include nested subqueries, such as subqueries in the FROM clause or scalar subqueries in the SELECT…
Question
Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)
Options
- AThey can include ORDER BY clauses.
- BThey cannot include nested subqueries.
- CThey can include context functions, such as CURRENT_TIME().
- DThey can support MIN and MAX aggregates.
- EThey can support inner joins, but not outer joins.
How the community answered
(26 responses)- B96% (25)
- E4% (1)
Explanation
According to the Snowflake documentation, materialized views have some limitations on the query specification that defines them. One of these limitations is that they cannot include nested subqueries, such as subqueries in the FROM clause or scalar subqueries in the SELECT list. Another limitation is that they cannot include ORDER BY clauses, context functions (such as CURRENT_TIME()), or outer joins. However, materialized views can support MIN and MAX aggregates, as well as other aggregate functions, such as SUM, COUNT, and AVG.
Topics
Community Discussion
No community discussion yet for this question.