ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 2 question 103 discussion

Actual exam question from Microsoft's DP-203
Question #: 103
Topic #: 2
[All DP-203 Questions]

HOTSPOT
-

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.

Show Suggested Answer Hide Answer
Suggested Answer:
by Yemeral at May 5, 2023, 11:20 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Yemeral
Highly Voted 2 years, 1 month ago
Correct. It's weird but best way to open a json is as a csv and with 0x0b for fieldterminator and fieldquote. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-json-files
upvoted 32 times
...
c430fb7
Highly Voted 11 months, 2 weeks ago
GPT would fail this exam and still explain the incorrect answers like a PRO
upvoted 6 times
...
Alongi
Most Recent 1 year, 3 months ago
It's correct
upvoted 1 times
...
dakku987
1 year, 4 months ago
I got this question today in exam 11-jan-2024
upvoted 6 times
...
kkk5566
1 year, 9 months ago
Correct
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel