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 212 discussion

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

What is a limitation of a Materialized View?

  • A. A Materialized View cannot support any aggregate functions
  • B. A Materialized View can only reference up to two tables
  • C. A Materialized View cannot be joined with other tables
  • D. A Materialized View cannot be defined with a JOIN
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by tejarun at Nov. 26, 2022, 1:04 a.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
tejarun
Highly Voted 2 years, 5 months ago
Selected Answer: D
Materialized view can be joined with other tables. But you cannot include JOIN in a materialized view definition
upvoted 7 times
...
Josa2
Highly Voted 2 years, 2 months ago
Selected Answer: D
D, how come that som many answers from basic definitions are wrong?
upvoted 5 times
Thaiya
1 year, 8 months ago
https://docs.snowflake.com/en/user-guide/views-materialized, can be used with a Join is a clear statement here.
upvoted 1 times
Thaiya
1 year, 8 months ago
sorry i read the option wrong. this is correct
upvoted 1 times
...
...
...
hotflake
Most Recent 9 months, 1 week ago
A. A Materialized View cannot support any aggregate functions - Wrong - supports few aggregate functions but with some restrictions. B. A Materialized View can only reference up to two tables - Wrong - can query only a single table. C. A Materialized View cannot be joined with other tables - Wrong - We can. D. A Materialized View cannot be defined with a JOIN - Correct - Joins, including self-joins, are not supported.
upvoted 1 times
...
Mallikharjuna452
9 months, 3 weeks ago
D is correct
upvoted 1 times
...
_yyukta
1 year, 2 months ago
Selected Answer: D
D is correct
upvoted 1 times
...
DavidMiller
1 year, 4 months ago
answer is. D
upvoted 1 times
...
lol632
1 year, 5 months ago
Answer C does not make any sense at all. There is no concept of joining materialized views by another tables. Tables, per se, can join. So answer is D
upvoted 2 times
...
[Removed]
1 year, 6 months ago
Selected Answer: D
https://docs.snowflake.com/en/user-guide/views-materialized#limitations-on-creating-materialized-views Answer is correct
upvoted 2 times
...
Thaiya
1 year, 8 months ago
Answer is B. Query results contain a small number of rows and/or columns relative to the base table (the table on which the view is defined).The base table, only one table.
upvoted 1 times
Thaiya
1 year, 8 months ago
D is correct, can be used with Join.
upvoted 1 times
...
...
jackjack123
1 year, 9 months ago
@SexyPotato option B says 2 tables. Only D is correct.
upvoted 1 times
...
SexyPotato
2 years, 2 months ago
Selected Answer: D
D is the answer, but B is also correct, in that you can only reference 1 table.
upvoted 2 times
...
AS314
2 years, 4 months ago
Selected Answer: D
https://docs.snowflake.com/en/user-guide/views-materialized.html#limitations-on-creating-materialized-views
upvoted 2 times
...
db1290
2 years, 5 months ago
Selected Answer: D
Answer is D
upvoted 2 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