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.3%

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

20.4%

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

15.7%

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

13.9%

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

3.7%

Databricks Certified Data Engineer - Professional