Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

Microsoft Exam DP-500 Topic 8 Question 38 Discussion

Actual exam question for Microsoft's DP-500 exam

Question #: 38
Topic #: 8

[All DP-500 Questions]

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 are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.

The queries use open row set and infer the schema shown in the following table.

You need to recommend changes to the queries to reduce I/O reads and tempdb usage.

Solution: You recommend using openrowset with to explicitly specify the maximum length for businessName and surveyName.

Does this meet the goal?

AYes

BNo

Show Suggested Answer

Suggested Answer: A, B, D

by Carissa at Apr 20, 2024, 12:41 PM

Limited Time Offer

25%

Off

Get Premium DP-500 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Kimberlie

11 months ago

That's a good point, We should definitely consider Reader role as well for proper access control.

upvoted 0 times

...

Allene

11 months ago

I believe assigning Reader role will also be necessary for accessing the dataflows in Power BI workspace.

upvoted 0 times

...

Jamika

11 months ago

I agree with the Storage Blob Data Contributor role should be enough for storing dataflows.

upvoted 0 times

...

Kimberlie

11 months ago

I think we should assign Storage Blob Data Contributor role for storage1.

upvoted 0 times

...

Kristofer

12 months ago

Agreed. And maybe the Reader role as well for least privilege access.

upvoted 0 times

...

Ceola

12 months ago

Yes, that sounds right. We should also assign the Storage Blob Data Reader role for storage1.

upvoted 0 times

...

Jackie

12 months ago

I think we should assign the Storage Blob Data Contributor role for storage1.

upvoted 0 times

Thurman

11 months ago

I agree with assigning the Storage Blob Data Contributor role, but we should also assign the Storage Blob Data Reader role.

upvoted 0 times

...

Cordelia

12 months ago

Hmm, maybe we should also consider assigning the Contributor role.

upvoted 0 times

...

Janna

12 months ago

Actually, I think we should assign the Storage Blob Data Owner role.

upvoted 0 times

...

Lezlie

12 months ago

I'm not sure about that, I think we should assign the Reader role instead.

upvoted 0 times

...

Reta

12 months ago

I think we also need to assign the Storage Blob Data Reader role.

upvoted 0 times

...

Lanie

12 months ago

I agree, we should definitely assign the Storage Blob Data Contributor role.

upvoted 0 times

...

...

Kristofer

12 months ago

We need to configure a Power BI workspace to store dataflows in storage1.

upvoted 0 times

...