Microsoft Data Engineering on Microsoft Azure DP-203 Question # 17 Topic 2 Discussion

Microsoft Data Engineering on Microsoft Azure DP-203 Question # 17 Topic 2 Discussion

DP-203 Exam Topic 2 Question 17 Discussion:
Question #: 17
Topic #: 2

You plan to use an Apache Spark pool in Azure Synapse Analytics to load data to an Azure Data Lake Storage Gen2 account.

You need to recommend which file format to use to store the data in the Data Lake Storage account. The solution must meet the following requirements:

• Column names and data types must be defined within the files loaded to the Data Lake Storage account.

• Data must be accessible by using queries from an Azure Synapse Analytics serverless SQL pool.

• Partition elimination must be supported without having to specify a specific partition.

What should you recommend?


A.

Delta Lake


B.

JSON


C.

CSV


D.

ORC


Get Premium DP-203 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.