Answer-first summary for fast verification
Answer: Predictive optimization must be enabled for the table.
Automatic liquid clustering requires predictive optimization to be enabled because Databricks uses historical query workload analysis to choose clustering keys. Partitioning and ZORDER are not required (and are incompatible with liquid clustering).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You have a Unity Catalog managed Delta table and want automatic liquid clustering to work. Which requirement must be met?
A
Predictive optimization must be enabled for the table.
B
The table must be partitioned.
C
The table must have ZORDER enabled.
D
The table must be under 10 TB.
No comments yet.