DP-203 Certification Practice Question #174

Question

You have an Azure Blob storage account that contains a folder. The folder contains 120,000 files. Each file contains 62 columns.

Each day, 1,500 new files are added to the folder.

You plan to incrementally load five data columns from each new file into an Azure Synapse Analytics workspace.

You need to minimize how long it takes to perform the incremental loads.

What should you use to store the files and in which format? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

The fastest incremental pattern is to organize incoming files with time-partitioned folders or names so the pipeline can target only the new daily slice instead of rescanning the whole 120,000-file corpus. For the file format, Parquet is the better choice because the workload reads only five out of 62 columns, and Parquet?s columnar layout reduces I/O compared with CSV. That combination minimizes both file discovery work and per-file read cost.

More DP-203 practice questions