Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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;
Explanation:
To enable automatic liquid clustering on a new table, use CLUSTER BY AUTO.
