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

Question

Options

• ACreate multiple clustering keys for a table.
• BCreate multiple materialized views with different cluster keys.
• CCreate super projections that will automatically create clustering.
• DCreate a clustering key that contains all columns used in the access paths.

• A
  3% (1)
• B
  79% (27)
• C
  12% (4)
• D
  6% (2)

Explanation

A Snowflake table supports only a single clustering key, so you cannot create multiple clustering keys on the same table (eliminating option A). To optimize for different access paths - for example, one workload filtering by date and another by region - the best practice is to create multiple materialized views, each with a different clustering key suited to its specific access pattern. Materialized views in Snowflake maintain their own physical storage and can have independent cluster keys. Option D (a single key covering all columns) would be inefficient and unlikely to benefit all access paths equally. Option C is fabricated - 'super projections' do not exist in Snowflake.

No community discussion yet for this question.