nerdexam
Snowflake

COF-R02 · Question #147

Which of the following describes how clustering keys work in Snowflake?

The correct answer is B. Clustering keys sort the designated columns over time, without blocking DML operations. See the full explanation below for the reasoning.

Question

Which of the following describes how clustering keys work in Snowflake?

Options

  • AClustering keys update the micro-partitions in place with a full sort, and impact the DML
  • BClustering keys sort the designated columns over time, without blocking DML operations
  • CClustering keys create a distributed, parallel data structure of pointers to a table's rows and
  • DClustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at

How the community answered

(38 responses)
  • A
    3% (1)
  • B
    84% (32)
  • C
    3% (1)
  • D
    11% (4)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice