DP-200 Exam QuestionsBrowse all questions from this exam

DP-200 Exam - Question 32


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 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?

Show Answer
Correct Answer: B

To ensure that the data copies quickly from Azure Storage to an Azure SQL data warehouse, it is important to optimize the size of each row. Rows larger than 1 MB can result in performance issues during the copy process. Therefore, the files should be modified to ensure that each row is less than 1 MB, not more. This helps to achieve faster data transfer and processing efficiency.

Discussion

4 comments
Sign in to comment
clownfishman
Sep 30, 2020

one word, huge difference (less/more)

memo43
May 16, 2021

the answer is correct... NO

BungyTex
Sep 3, 2020

The answer is A. The description is literally what is said in A.

BungyTex
Sep 3, 2020

Ignore my comment, the answer is B. I misread.

dduque10
Sep 16, 2021

This answer contradicts the last one