Microsoft Exam DP-500 Topic 11 Question 11 Discussion

Actual exam question for Microsoft's DP-500 exam

Question #: 11
Topic #: 11

You are creating an external table by using an Apache Spark pool in Azure Synapse Analytics. The table will contain more than 20 million rows partitioned by date. The table will be shared with the SQL engines.

You need to minimize how long it takes for a serverless SQL pool to execute a query data against the table.

In which file format should you recommend storing the table data?

AJSON

BApache Parquet

CCSV

DDelta

Show Suggested Answer

Suggested Answer: C

by Kimbery at Sep 20, 2022, 12:44 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

phil shultz

2 years ago

this documentation suggests parquet. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-serverless-sql-pool

upvoted 1 times

...

brendan daly

2 years ago

It is parquet, the serverless is the giveaway

upvoted 1 times

brendan daly

2 years ago

also apache spark, apache parquet

upvoted 1 times

...