Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 64 discussion

Actual exam question from Microsoft's DP-203

Question #: 64
Topic #: 1

You are designing an Azure Data Lake Storage solution that will transform raw JSON files for use in an analytical workload.
You need to recommend a format for the transformed files. The solution must meet the following requirements:
✑ Contain information about the data types of each column in the files.
✑ Support querying a subset of columns in the files.
✑ Support read-heavy analytical workloads.
✑ Minimize the file size.
What should you recommend?

A. JSON
B. CSV
C. Apache Avro
D. Apache Parquet

Show Suggested Answer

Suggested Answer: D 🗳️

by anks84 at Sept. 6, 2022, 3:44 a.m.

Comments

Submit Cancel

ajhak

Highly Voted 1 year, 12 months ago

Selected Answer: D

Parquet has columnar format, best for reading a few columns. Also when in doubt, just select Parquet. More often than not, that is gonna be the correct answer if you don't know it.

upvoted 13 times

...

anks84

Highly Voted 2 years, 8 months ago

Correct as the requirement is Column based.

upvoted 7 times

...

EmnCours

Most Recent 5 months, 2 weeks ago

Selected Answer: D

Correct Answer: D

upvoted 1 times

...

Piantoni

6 months ago

The answer is "D"

upvoted 1 times

...

kkk5566

1 year, 8 months ago

Selected Answer: D

D is correct

upvoted 2 times

...

Reloadedvn

2 years ago

Selected Answer: D

Parquet format satisfies all reqs

upvoted 2 times

...

GodfreyMbizo

2 years, 3 months ago

Parquet

upvoted 3 times

...

youngbug

2 years, 5 months ago

Selected Answer: D

Avro is totally a serialization format. It combines of JSON and Raw binary files. Why is the explanation like this? It's misleading.

upvoted 4 times

...

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 64 discussion

Comments

ajhak

anks84

EmnCours

Piantoni

kkk5566

Reloadedvn

GodfreyMbizo

youngbug

SY0-701