Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-203 Topic 1 Question 107 Discussion

Actual exam question for Microsoft's DP-203 exam
Question #: 107
Topic #: 1
[All DP-203 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

Kayleigh
1 months ago
I'd say C) JSON is the way to go. It's like trying to use a wrench to hammer a nail - it just doesn't make sense. Let's keep it simple and stick to the format that was literally mentioned in the question.
upvoted 0 times
...
Lindsey
2 months ago
Hah, this is a no-brainer! C) JSON is the way to go. It's like trying to fit a square block into a round hole with any of the other options. Come on, people, let's use our brains here!
upvoted 0 times
Rhea
1 months ago
User2: Yeah, using JSON with openrowset function is the best way to read the files in storage1.
upvoted 0 times
...
Loise
1 months ago
User1: I agree, C) JSON is definitely the right choice for this.
upvoted 0 times
...
...
Millie
2 months ago
I'm not sure, but I think JSON is the correct format for reading JSON records.
upvoted 0 times
...
Barrie
2 months ago
C) JSON all the way! I mean, who wants to read files in PARQUET or CSV format when you can get your hands dirty with some good old JSON, am I right? Wink wink, nudge nudge.
upvoted 0 times
Precious
26 days ago
D) DELTA
upvoted 0 times
...
Alisha
27 days ago
C) JSON
upvoted 0 times
...
Lai
1 months ago
B) CSV
upvoted 0 times
...
Pedro
1 months ago
A) PARQUET
upvoted 0 times
...
...
Ryan
2 months ago
I agree with Theodora, setting the format option to JSON makes sense in this case.
upvoted 0 times
...
Launa
2 months ago
I'm going to go with C) JSON. Anything else would just be a square peg in a round hole, am I right?
upvoted 0 times
...
Vanna
2 months ago
Hmm, the question mentions JSON records, so C) JSON seems like the obvious choice here. Can't go wrong with good ol' JSON!
upvoted 0 times
Kenneth
26 days ago
JSON is the clear choice for reading the files in storage1.
upvoted 0 times
...
Carry
1 months ago
I think JSON is the most suitable format for reading those files.
upvoted 0 times
...
Nell
1 months ago
Yeah, JSON is definitely the best option for this scenario.
upvoted 0 times
...
Rikki
1 months ago
I agree, JSON is the way to go for reading those files.
upvoted 0 times
...
German
2 months ago
JSON is the most suitable choice for reading those files in storage1.
upvoted 0 times
...
Marilynn
2 months ago
Yeah, JSON is the best format option for this scenario.
upvoted 0 times
...
Dong
2 months ago
I agree, JSON is definitely the way to go for reading those files.
upvoted 0 times
...
...
Theodora
2 months ago
I think the answer is C) JSON because we need to read JSON records.
upvoted 0 times
...

Save Cancel