ClickHouse Certified Practice Questions - ClickHouse Certified Developer Exam

What is the purpose of PARTITION BY in a MergeTree table?

It defines the sort order of data within each data part It splits data into separate directories, enabling partition pruning for WHERE filters It determines which shard a row is routed to in a distributed cluster It sets the primary key prefix used for the sparse index

Correct Answer:

It splits data into separate directories, enabling partition pruning for WHERE filters

Access more questions from this quiz

Continue to ClickHouse Certified Practice Questions - ClickHouse Certified Developer Exam for more practice questions and the full quiz experience.

Access More Questions