Black Friday Reward - Upto 75% off - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

Snowflake SnowPro Advanced: Administrator ADA-C02 Question # 7 Topic 1 Discussion

Snowflake SnowPro Advanced: Administrator ADA-C02 Question # 7 Topic 1 Discussion

ADA-C02 Exam Topic 1 Question 7 Discussion:
Question #: 7
Topic #: 1

If a query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?


A.

No, because joins are not supported by materialized views.


B.

No, because the optimizer might decide against it.


C.

No, because the materialized view may not be up-to-date.


D.

Yes, because materialized views are always faster.


Get Premium ADA-C02 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.