Which statement correctly creates a partitioned delta table named `records` based on the `year` and `month` columns?

Real Exam

CREATE TABLE records (id int, year int, month int) PARTITIONED BY (year, month);

46.8%

CREATE TABLE records (id int, year int, month int) PARTITION BY (year, month);

20.2%

CREATE TABLE records (id int, year int, month int) PARTITION BY year, month;

15.6%

CREATE TABLE records (id int, year int, month int) PARTITIONED BY year, month;

13.8%

CREATE TABLE records (id int, year int, month int) PARTITION BY (year and month);

3.7%

Databricks Certified Data Engineer - Professional