BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-203 Topic 9 Question 2 Discussion

Actual exam question for Microsoft's DP-203 exam
Question #: 2
Topic #: 9
[All DP-203 Questions]

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an Azure Storage account that contains 100 GB of files. The files contain text and numerical values. 75% of the rows contain description data that has an average length of 1.1 MB.

You plan to copy the data from the storage account to an enterprise data warehouse in Azure Synapse Analytics.

You need to prepare the files to ensure that the data copies quickly.

Solution: You convert the files to compressed delimited text files.

Does this meet the goal?

Show Suggested Answer Hide Answer
Suggested Answer: A

All file formats have different performance characteristics. For the fastest load, use compressed delimited text files.


https://docs.microsoft.com/en-us/azure/sql-data-warehouse/guidance-for-loading-data

Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel