ARA-C01 · Question #170
Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?
The correct answer is B. Materialized view. A materialized view can be defined with its own cluster key that is different from the cluster key of the underlying base table. This allows the same data to be physically organized differently for different query patterns - the base table can be clustered on one dimension…
Question
Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?
Options
- AExternal table
- BMaterialized view
- CSearch optimization
- DResult cache
How the community answered
(16 responses)- A6% (1)
- B88% (14)
- C6% (1)
Explanation
A materialized view can be defined with its own cluster key that is different from the cluster key of the underlying base table. This allows the same data to be physically organized differently for different query patterns - the base table can be clustered on one dimension (e.g., customer_id) while a materialized view on that table is clustered on another (e.g., date). External tables (A) don't support custom cluster keys on Snowflake-managed storage. Search optimization (C) improves selective point-lookup queries but does not define cluster keys. Result cache (D) stores query output temporarily for repeated identical queries and has nothing to do with clustering definitions.
Topics
Community Discussion
No community discussion yet for this question.