DATABRICKS-DEA Question 112

Question

Which SQL command creates a partitioned table by date?
A. CREATE TABLE t (id INT, date STRING) CLUSTERED BY (date)
B. CREATE TABLE t (id INT, date STRING) PARTITIONED BY (date)
C. CREATE TABLE t (id INT, date STRING) ZORDER BY (date)
D. CREATE TABLE t (id INT, date STRING) DISTRIBUTED BY (date)

Accepted Answer

Marked answer: B. CREATE TABLE t (id INT, date STRING) PARTITIONED BY (date)

DATABRICKS-DEA Question 112

Community Discussion

Preparing Practice Exam…

DATABRICKS-DEA Question 112

Community Discussion