nerdexam
Microsoft

DP-203 · Question #103

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…

The correct answer is B. No. Instead modify the files to ensure that each row is less than 1 MB. https://docs.microsoft.com/en-us/azure/sql-data-warehouse/guidance-for-loading-data

Submitted by thandi_sa· Mar 30, 2026Design and implement data storage

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 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 Azure SQL data warehouse. You need to prepare the files to ensure that the data copies quickly. Solution: You modify the files to ensure that each row is more than 1 MB. Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(59 responses)
  • A
    25% (15)
  • B
    75% (44)

Explanation

Instead modify the files to ensure that each row is less than 1 MB. https://docs.microsoft.com/en-us/azure/sql-data-warehouse/guidance-for-loading-data

Topics

#Azure Storage#file format selection#compression#data layout

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice