Exam DP-203 topic 1 question 85 discussion

Actual exam question from Microsoft's DP-203

Question #: 85
Topic #: 1

You have an Azure Data Lake Storage Gen2 account named storage1.

You plan to implement query acceleration for storage1.

Which two file types support query acceleration? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

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

Show Suggested Answer

Suggested Answer: AD 🗳️

by IanKwok81 at June 8, 2023, 2:37 p.m.

Comments

Submit Cancel

orionduo

Highly Voted 2 years, 1 month ago

Correct. Query acceleration supports CSV and JSON formatted data as input to each request. https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-query-acceleration

upvoted 11 times

...

vctrhugo

Highly Voted 2 years, 2 months ago

Selected Answer: AD

Query acceleration supports CSV and JSON formatted data as input to each request.

upvoted 6 times

...

sachin_mt

Most Recent 4 months, 4 weeks ago

Selected Answer: BE

B & E options

upvoted 1 times

...

Moli62

5 months ago

Selected Answer: AD

https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-query-acceleration

upvoted 1 times

...

jxs221

5 months, 1 week ago

Selected Answer: BE

Parquet is a columnar format, allowing efficient data retrieval and compression. Avro is optimized for efficient binary serialization, making it suitable for query acceleration.

upvoted 1 times

...

angelvenkovicch

5 months, 3 weeks ago

Selected Answer: D

is this related to DP-300 or not

upvoted 1 times

...

samirarian

6 months ago

Selected Answer: BE

These file formats are optimized for analytics and support features like columnar storage, which is beneficial for query acceleration, making them more efficient for querying in big data analytics workloads. Parquet: A columnar storage format that is widely used for analytics, providing fast query performance. Avro: A row-based storage format that also supports efficient querying, particularly with its schema support and compact data format. So, Parquet and Avro are the correct answers.

upvoted 1 times

...