Answer-first summary for fast verification
Answer: ALTER TABLE transactions CLUSTER BY (transaction_id);
Enable liquid clustering on an existing unpartitioned Delta table using: ALTER TABLE <table_name> CLUSTER BY (<clustering_columns>).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You have an unpartitioned Delta table transactions and want to enable liquid clustering on transaction_id. Which command should you run?
A
ALTER TABLE transactions CLUSTER BY (transaction_id);
B
ALTER TABLE transactions ZORDER BY (transaction_id);
C
ALTER TABLE transactions PARTITION BY (transaction_id);
D
OPTIMIZE transactions CLUSTER BY (transaction_id);
No comments yet.