Given the source path for an Auto Loader is set as `s3://records/year=2023/month=11/season1.parquet`, which of the following statements accurately describes the partitioning details inferred from this path?

Real Exam

The year column will be inferred as the partition column, as Auto Loader supports partitioning only on one column.

1.5%

The month column will be inferred as the partition column, as Auto Loader supports partitioning only on one column.

4.4%

Auto Loader does not support partitioning inference, hence no column will be selected as a partition column.

11.8%

Both year and month columns will be inferred as the partition columns.

79.4%

A new column named year_month will be created for partitioning._

2.9%

Databricks Certified Data Engineer - Professional