Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 22 discussion

Actual exam question from Microsoft's DP-203

Question #: 22
Topic #: 1

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 convert the files to compressed delimited text files.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️

by kolakone at Sept. 19, 2021, 6:29 a.m.

Comments

Submit Cancel

Fahd92

Highly Voted 3 years, 10 months ago

They said you need to prepare the files to copy, maybe the mean we should make them less than 1MB ? so it will be A else would be B !!!!

upvoted 18 times

ANath

3 years, 7 months ago

The answer should be A. https://azure.microsoft.com/en-gb/blog/increasing-polybase-row-width-limitation-in-azure-sql-data-warehouse/

upvoted 5 times

...

Thij

3 years, 10 months ago

After reading the other questions oh this topic I go with A because the relevant part seems to be the compression.

upvoted 4 times

11 months ago

The answer is A Compression doesn't not only help to reduce the size or space occupied by a file in a storage but also increases the speed of file movement during transfer

upvoted 2 times

...

SHENOOOO

2 years, 6 months ago

Selected Answer: A

A will do the job

upvoted 3 times

...

3 years ago

Selected Answer: A 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. All file formats have different performance characteristics. For the fastest load, use compressed delimited text files. Split large compressed files into smaller compressed files.

upvoted 3 times

dgerok

1 year, 4 months ago

PolyBase can load more than 1 mln rows since SQL Server 2019 https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-versioned-feature-summary?view=sql-server-ver16

upvoted 1 times

...

Deepshikha1228

3 years ago

A is correct ,with copy command PolyBase COPY Needs CONTROL permission Relaxed permission Has row width limits No row width limit No delimiters within text Supports delimiters in text Fixed line delimiter Supports custom column and row delimiters Complex to set up in code Reduces amount of code

upvoted 2 times

...

objecto

3 years, 2 months ago

Selected Answer: A

It's just a copy to storage so zipping it will work fine.

upvoted 4 times

...

Rrk07

3 years, 2 months ago

It says about files compression. which will reduce the file size. so Answer is correct

upvoted 1 times

...

Load full discussion...