Snowflake Exam SnowPro-Core Topic 7 Question 81 Discussion

Actual exam question for Snowflake's SnowPro-Core exam

Question #: 81
Topic #: 7

[All SnowPro-Core Questions]

Which statement accurately describes a characteristic of a materialized view?

AA materialized view can query only a single table.

BData accessed through materialized views can be stale.

CMaterialized view refreshes need to be maintained by the user.

DQuerying a materialized view is slower than executing a query against the base table of the view.

Show Suggested Answer

Suggested Answer: A

by Beatriz at Feb 12, 2024, 05:33 PM

Limited Time Offer

25%

Off

Get Premium SnowPro-Core Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Kimberely

6 months ago

I'm not sure, but I think querying a materialized view is slower than executing a query against the base table of the view, so the answer might be D)

upvoted 0 times

...

Mattie

7 months ago

I disagree, I believe the correct answer is C) Materialized view refreshes need to be maintained by the user.

upvoted 0 times

...

Jill

7 months ago

I think the answer is B) Data accessed through materialized views can be stale.

upvoted 0 times

...

Micaela

7 months ago

Sylvia makes a good point, maintaining materialized view refreshes can be crucial for accuracy.

upvoted 0 times

...

Sylvia

7 months ago

I disagree, I believe the answer is C) Materialized view refreshes need to be maintained by the user.

upvoted 0 times

...

In

8 months ago

I agree with Rusty, data in materialized views can indeed be stale.

upvoted 0 times

...

Rusty

8 months ago

I think the correct answer is B) Data accessed through materialized views can be stale.

upvoted 0 times

...