Answer-first summary for fast verification
Answer: CREATE TABLE sales (customer_id STRING, order_date DATE) CLUSTER BY (customer_id, order_date);
"To enable liquid clustering, add the CLUSTER BY phrase to a table creation statement." Partitioning and ZORDER are incompatible with liquid clustering
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are creating a Delta table that will be frequently queried by customer_id and order_date. You want to enable liquid clustering during creation. Which SQL command is correct according to the documentation?
A
CREATE TABLE sales (customer_id STRING, order_date DATE) PARTITIONED BY (customer_id, order_date);
B
CREATE TABLE sales (customer_id STRING, order_date DATE) CLUSTER BY (customer_id, order_date);
C
CREATE TABLE sales (customer_id STRING, order_date DATE) ZORDER BY (customer_id, order_date);
D
CREATE TABLE sales (customer_id STRING, order_date DATE) CLUSTER BY AUTO;
No comments yet.