Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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;
