Microsoft
DP-203 · Question #319
You have an Azure subscription that contains the resources shown in the following table. You need to read the files in storage1 by using ad-hoc queries and the OPENROWSET function. The solution must e
Sign in or unlock DP-203 to reveal the answer and full explanation for question #319. The question stem and answer options stay visible for context.
Submitted by packet_pusher· Mar 30, 2026Develop data processing
Question
You have an Azure subscription that contains the resources shown in the following table. You need to read the files in storage1 by using ad-hoc queries and the OPENROWSET function. The solution must ensure that each rowset contains a single JSON record. To what should you set the FORMAT option of the OPENROWSET function?
Exhibit
Options
- AJSON
- BDELTA
- CPARQUET
- DCSV
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#OPENROWSET#JSON#serverless SQL pool#FORMAT option