What is a characteristic of materialized views in Snowflake?
A.
Materialized views do not allow joins.
B.
Clones of materialized views can be created directly by the user.
C.
Multiple tables can be joined in the underlying query of a materialized view.
D.
Aggregate functions can be used as window functions in materialized views.
The Answer Is:
C
This question includes an explanation.
Explanation:
One of the characteristics of materialized views in Snowflake is that they allow multiple tables to be joined in the underlying query. This enables the pre-computation of complex queries involving joins, which can significantly improve the performance of subsequent queries that access the materialized view4. References: [COF-C02] SnowPro Core Certification Exam Study Guide
SnowPro-Core PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"