SnowPro Advanced: Architect — Question 36

How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?

Answer options

• A. Create multiple clustering keys for a table.
• B. Create multiple materialized views with different cluster keys.
• C. Create super projections that will automatically create clustering.
• D. Create a clustering key that contains all columns used in the access paths.

Correct answer: B

Explanation

The correct answer, B, is effective because it allows for different materialized views to optimize performance based on varying access patterns. Option A is incorrect since multiple clustering keys can complicate performance rather than enhance it. Option C doesn't directly address the clustering for access paths, and option D could lead to inefficiencies due to unnecessary complexity in the clustering key.