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.
Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)
-
answerhappygod
- Site Admin
- Posts: 895507
- Joined: Mon Aug 02, 2021 8:13 am
Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying! For more answers search our other sites: AnswerAccurate HomeworkAnswerHelp QuestionAnswerDump and Snapsterpiece