Answer-first summary for fast verification
Answer: CREATE TABLE events (event_id STRING, event_time TIMESTAMP) CLUSTER BY AUTO;
To enable automatic liquid clustering on a new table, use CLUSTER BY AUTO.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You want Databricks to automatically choose clustering keys for a new table events. Which SQL command is correct?
A
CREATE TABLE events (event_id STRING, event_time TIMESTAMP) CLUSTER BY AUTO;
B
CREATE TABLE events (event_id STRING, event_time TIMESTAMP) CLUSTER BY (AUTO);
C
CREATE TABLE events (event_id STRING, event_time TIMESTAMP) AUTO CLUSTER;
D
CREATE TABLE events (event_id STRING, event_time TIMESTAMP) PARTITION BY AUTO;
No comments yet.