Answer-first summary for fast verification
Answer: Z-ordering optimizes the files to create similar-size files based on the number of rows.
Z-ordering enhances query performance by colocating similar data, facilitating data skipping. This optimization is based on evenly distributing data according to the number of rows, not the file size on disk. For more details, refer to Z-ordering in Databricks documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How does Z-ordering optimize performance for a Delta table?
A
Z-ordering optimizes the files to create similar-size files based on their size on disk.
B
Z-ordering works only on the text data columns.
C
Z-ordering collects the min and max values of each column and adds them to another table.
D
Z-ordering optimizes the files to create similar-size files based on the number of rows.
E
Z-ordering clears the column with text-only data before performing the ordering.