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

Exam SnowPro Core All Questions

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

Exam SnowPro Core topic 1 question 1266 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 1266
Topic #: 1
[All SnowPro Core Questions]

When would creating and using a standard view be preferable to using a materialized view?

  • A. The underlying query of the view takes a lot of time to run.
  • B. The underlying query of the view is resource-intensive.
  • C. The underlying query of the view is run on large data sets.
  • D. The view results change often.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by MultiCloudIronMan at Jan. 10, 2025, 5:38 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
37ceea2
2 months, 2 weeks ago
My bad, the question is about when standard view is preferable vs MATERIALZIED VIEW. Answer is D.
upvoted 1 times
...
37ceea2
2 months, 4 weeks ago
Selected Answer: B
Exact definition of the Materialized views is that the underlying query is not changing often. Exact definition says that the Materialized views are necessary when it is about query compute resource intensive and complex. The answer is B
upvoted 1 times
37ceea2
2 months, 2 weeks ago
My bad, the question is about when standard view is preferable vs MATERIALZIED VIEW. Answer is D.
upvoted 1 times
...
...
MultiCloudIronMan
3 months, 1 week ago
Selected Answer: D
its correct
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago