exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 24 discussion

Actual exam question from Microsoft's DP-203
Question #: 24
Topic #: 1
[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 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 rows of 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 more than 1 MB.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Gilvan
Highly Voted 3 years, 8 months ago
No, rows need to have less than 1 MB. A batch size between 100 K to 1M rows is the recommended baseline for determining optimal batch size capacity.
upvoted 13 times
...
amarG1996
Highly Voted 3 years, 4 months ago
PolyBase can't load rows that have more than 1,000,000 bytes of data. When you put data into the text files in Azure Blob storage or Azure Data Lake Store, they must have fewer than 1,000,000 bytes of data. This byte limitation is true regardless of the table schema.
upvoted 8 times
kamil_k
3 years, 2 months ago
is it stated anywhere that we have to use PolyBase? What about COPY command?
upvoted 2 times
...
amarG1996
3 years, 4 months ago
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/data-loading-best-practices#prepare-data-in-azure-storage
upvoted 2 times
...
...
moize
Most Recent 5 months, 2 weeks ago
Selected Answer: B
Selon Copilot : Non, modifier les fichiers pour garantir que chaque ligne fait plus de 1 Mo n'est pas nécessairement la meilleure solution pour garantir une copie rapide des données vers Azure Synapse Analytics. En fait, cela pourrait même compliquer le processus de copie et de traitement des données.
upvoted 2 times
...
EmnCours
5 months, 2 weeks ago
Selected Answer: B
Correct Answer: B
upvoted 1 times
...
kkk5566
1 year, 8 months ago
Selected Answer: B
Answer is no
upvoted 1 times
...
vigilante89
2 years, 5 months ago
Selected Answer: B
B is correct!!!
upvoted 2 times
...
Deeksha1234
2 years, 9 months ago
B is correct, agree with explanation by Amar
upvoted 1 times
...
PallaviPatel
3 years, 3 months ago
Selected Answer: B
B is correct.
upvoted 4 times
...
Mahesh_mm
3 years, 4 months ago
Answer is No
upvoted 1 times
...
rashjan
3 years, 5 months ago
Selected Answer: B
Correct Answer: No.
upvoted 2 times
...
Odoxtoom
3 years, 6 months ago
Consider this sets one question: What should you do to improve loading times? What | Yes | No | compressed | O | O | columnstore | O | O | > 1MB | O | O | So now answers should be clear
upvoted 1 times
Aslam208
3 years, 5 months ago
@Odoxtoom, can you please explain your answer and specify based on this matrix which option is correct.
upvoted 5 times
Bishtu
3 years, 4 months ago
Yes No No
upvoted 2 times
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago