SnowPro Advanced: Architect — Question 45

Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?

Answer options

• A. External table
• B. Materialized view
• C. Search optimization
• D. Result cache

Correct answer: B

Explanation

The correct answer is B, as a Materialized view can be used to define an alternate cluster key for a table. The other options do not offer this capability; for instance, External tables and Result cache serve different purposes, and Search optimization focuses on improving query performance rather than modifying cluster keys.