Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Advanced: Architect · Snowflake
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Creating multiple materialized views with different cluster keys allows you to optimize for various access paths by distributing the data in ways that best suit each specific query pattern. This approach can significantly improve query performance as each materialized view can be tailored to different use cases, providing efficient access and faster retrieval times for specific queries.
D is correct
B THE PROBLEM: MULTIPLE ACCESS PATHS THE SOLUTION: CLUSTERED MATERIALIZED VIEW