Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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;