nerdexam
Snowflake

COF-R02 · Question #312

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

The correct answer is D. The columns most actively used in the select filters. See the full explanation below for the reasoning.

Question

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

Options

  • AThe columns that are queried in the select clause.
  • BThe columns with very high cardinality.
  • CThe columns with many different values.
  • DThe columns most actively used in the select filters.

How the community answered

(32 responses)
  • A
    9% (3)
  • B
    6% (2)
  • C
    3% (1)
  • D
    81% (26)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice