DP-203 Certification Practice Question #215

Question

You develop a dataset named DBTBL1 by using Azure Databricks.
DBTBL1 contains the following columns:
✑ SensorTypeID
✑ GeographyRegionID
✑ Year
✑ Month
✑ Day
✑ Hour
✑ Minute
✑ Temperature
✑ WindSpeed
✑ Other
You need to store the data to support daily incremental load pipelines that vary for each GeographyRegionID. The solution must minimize storage costs.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

The workload is explicitly described as daily incremental loads that vary by `GeographyRegionID`, so the partitioning strategy should align to both region and date granularity. Parquet is the strongest storage-cost choice because it is a compressed columnar format that reduces both storage footprint and read I/O. The exact partition column order is the only real ambiguity here; I give a slightly reduced confidence because some practitioners argue for date-first ordering to cut folder count, but the dominant signal and the requirement phrasing favor region-plus-date partitioning.

More DP-203 practice questions