Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which statement correctly creates a partitioned delta table named records based on the year and month columns?
records
year
month
A
CREATE TABLE records (id int, year int, month int) PARTITIONED BY (year, month);
B
CREATE TABLE records (id int, year int, month int) PARTITION BY (year, month);
C
CREATE TABLE records (id int, year int, month int) PARTITION BY year, month;
D
CREATE TABLE records (id int, year int, month int) PARTITIONED BY year, month;
E
CREATE TABLE records (id int, year int, month int) PARTITION BY (year and month);
