DP-203 Certification Practice Question #24

Question

You plan to implement an Azure Data Lake Storage Gen2 container that will contain CSV files. The size of the files will vary based on the number of events that occur per hour.
File sizes range from 4 KB to 5 GB.
You need to ensure that the files stored in the container are optimized for batch processing.
What should you do?

Accepted Answer

When the question emphasizes reusable metadata over data that remains in lake storage, Microsoft Learn guidance points toward external tables rather than repeatedly issuing ad hoc file queries or loading the data into dedicated internal tables. That makes the external-table pattern the best answer for this shared-data scenario.

More DP-203 practice questions