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…
The correct answer is D. CSV. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-json-files
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
How the community answered
(32 responses)- A3% (1)
- B16% (5)
- C6% (2)
- D75% (24)
Explanation
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-json-files
Topics
#OPENROWSET#JSON#serverless SQL pool#FORMAT option
Community Discussion
No community discussion yet for this question.