Microsoft Exam DP-203 Topic 1 Question 107 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 107
Topic #: 1

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?

APARQUET

BCSV

CJSON

DDELTA

Show Suggested Answer

Suggested Answer: C

by Sharika at Jan 14, 2025, 04:01 AM

Limited Time Offer

25%

Off

Get Premium DP-203 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Kayleigh

5 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

5 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

4 months ago

User2: Yeah, using JSON with openrowset function is the best way to read the files in storage1.

upvoted 0 times

...

Loise

4 months ago

User1: I agree, C) JSON is definitely the right choice for this.

upvoted 0 times

...

Millie

5 months ago

I'm not sure, but I think JSON is the correct format for reading JSON records.

upvoted 0 times

...

Barrie

5 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