DP-203 Certification Practice Question #25

Question

You store files in an Azure Data Lake Storage Gen2 container. The container has the storage policy shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

Microsoft Learn positions `OPENROWSET` as the primary serverless SQL mechanism for directly querying files in a data lake. When the exam wording is about ad hoc access rather than durable metadata, `OPENROWSET` is the most direct and appropriate answer, while external tables are the stronger option only when shared reusable metadata is part of the goal.

More DP-203 practice questions