Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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);
Explanation:
Enable liquid clustering on an existing unpartitioned Delta table using: ALTER TABLE <table_name> CLUSTER BY (<clustering_columns>).