DP-200 Exam - Question 31

Question

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 section, 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 modify the files to ensure that each row is less than 1 MB.

Does this meet the goal?

Examice · Accepted Answer

The correct solution to ensure quick data copying into Azure Synapse Analytics involves more than just modifying file sizes. While keeping each row under 1 MB might help with compatibility, the more effective approach involves compressing the files into delimited text formats which are optimized for loading into data warehouses. This ensures smaller file sizes and adheres to best practices for data loading in Azure Synapse Analytics.

JohnCrawford · Answer

The only thing I've found mentioning row size when doing the loads relates to loads using Polybase. Then the row size needs to less than 1 MB. https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse

MayankSh · Answer

Earlier, the answer to this question was "Yes", but now it shows as "No". Can someone confirm what is the correct answer ?

JaNieWiem · Answer

"Yes."

Simon2021 · Answer

Answer is Yes. File size should be less than 1 MB.

Nevia · Answer

Row size should be still maximum 1 MB. So answer is YES. Also according to latest updates https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-versioned-feature-summary?view=sql-server-ver15

dumpi · Answer

correct answer is B

hsetin · Answer

it is not just about the size, it is the approach. the recommended approach is about zipping the file.

hsetin · Answer

REcommended approach as per this: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/data-loading-best-practices

DP-200 Exam - Question 31

Discussion