ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam
Go to Exam

Exam SnowPro Advanced Architect topic 1 question 27 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect
Question #: 27
Topic #: 1
[All SnowPro Advanced Architect Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️
by serg_khar at April 7, 2023, 9:14 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
hillcat111
11 months, 1 week ago
Answer is B,D and is validated
upvoted 1 times
...
ManojRaghuwanshi
1 year ago
Selected Answer: BD
Time functions are non deterministic
upvoted 1 times
...
victorleonis
1 year ago
Selected Answer: BD
https://docs.snowflake.com/en/user-guide/views-materialized
upvoted 2 times
...
serg_khar
1 year, 2 months ago
Selected Answer: 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.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel