Databricks Certified Data Engineer - Professional

Ultimate access to all questions.

You want Databricks to automatically choose clustering keys for a new table events. Which SQL command is correct?

Exam-Like

A

CREATE TABLE events (event_id STRING, event_time TIMESTAMP) CLUSTER BY AUTO;

90.0%

B

CREATE TABLE events (event_id STRING, event_time TIMESTAMP) CLUSTER BY (AUTO);

2.5%

Loading comments...

C

CREATE TABLE events (event_id STRING, event_time TIMESTAMP) AUTO CLUSTER;

5.0%

D

CREATE TABLE events (event_id STRING, event_time TIMESTAMP) PARTITION BY AUTO;

2.5%

Powered ByGPT-5.2