Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

Question

Options

• AThe table contains a column that has very low cardinality
• BDML statements that are being issued against the table are blocked
• CThe table has a small number of micro-partitions
• DQueries on the table are running slower than expected: This can happen when the data in the
• EThe clustering depth for the table is large: A large clustering depth indicates that the table's

• A
  6% (1)
• B
  11% (2)
• C
  6% (1)
• D
  78% (14)

Explanation

Two signals indicate a clustering key may be beneficial. Slow-running queries (D) can occur when Snowflake must scan many micro-partitions because the data relevant to a query's filter is scattered-a clustering key co-locates related data and enables micro-partition pruning. A large clustering depth (E) measures how many micro-partitions overlap on a given column; a high value means data is poorly organized, so a clustering key (and automatic clustering) would compact and sort the data. Low cardinality (A) is a poor choice for a clustering key because it creates few distinct values and minimal pruning benefit. Blocked DML (B) is a concurrency/locking issue unrelated to clustering. A small number of micro-partitions (C) means the table is small and gains little from clustering.

No community discussion yet for this question.