SnowPro Advanced Architect Exam

Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam

Go to Exam

Question 27

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

They can include ORDER BY clauses.

They cannot include nested subqueries.

They can include context functions, such as CURRENT_TIME().

They can support MIN and MAX aggregates.

They can support inner joins, but not outer joins.

Correct Answer: B, D

Materialized views in Snowflake cannot include nested subqueries, and they support MIN and MAX aggregates. These are key characteristics because nested subqueries can be complex and impact performance, while MIN and MAX are common aggregate functions used in querying. Functions in materialized views must be deterministic, thus non-deterministic functions like CURRENT_TIME cannot be included.

Discussion

victorleonisOptions: BD

https://docs.snowflake.com/en/user-guide/views-materialized

hillcat111

Answer is B,D and is validated

ManojRaghuwanshiOptions: BD

Time functions are non deterministic

serg_kharOptions: BD

https://docs.snowflake.com/en/user-guide/views-materialized#limitations-on-creating-materialized-views * The aggregate functions that are supported in materialized views are: MIN/MAX * Functions used in a materialized view must be deterministic. For example, using CURRENT_TIME or CURRENT_TIMESTAMP is not permitted.