DP-203 Certification Practice Question #177

Question

You have an Azure Synapse serverless SQL pool.

You need to read JSON documents from a file by using the OPENROWSET function.

How should you complete the query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

In Synapse serverless SQL, the documented way to read raw JSON documents with `OPENROWSET` is intentionally to use `FORMAT = 'CSV'` with a control character (`0x0b`) for both the field terminator and field quote so that the JSON payload is treated as a single text value instead of being split incorrectly. That exact pattern is directly documented by Microsoft Learn and echoed by the community.

More DP-203 practice questions