Exam DP-500 topic 1 question 49 discussion

Actual exam question from Microsoft's DP-500

Question #: 49
Topic #: 1

HOTSPOT -
You manage a dataset that contains the two data sources as shown in the following table.

When you attempt to refresh the dataset in powerbi.com, you receive the following error message: “[Unable to combine data] Add Columns is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.”
You discover that the dataset contains queries that fold data from the SharePoint folder to the Azure SQL database.
You need to resolve the error. The solution must provide the highest privacy possible.
Which privacy level should you select for each data source? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by nbagchi at Dec. 13, 2022, 4:05 p.m.

Comments

Submit Cancel

Maazi

Highly Voted 2 years, 5 months ago

The answers ie Private and Organisational are correct. Ref: https://learn.microsoft.com/en-us/power-bi/enterprise/desktop-privacy-levels

upvoted 12 times

Maazi

2 years, 5 months ago

*Organisational = Organizational

upvoted 2 times

...

Eltooth

Most Recent 2 years ago

Agreed - Private and Organizational.

upvoted 1 times

...

stfglv

2 years, 4 months ago

Sensitive data --> must be private. The other dataset could theoretically be public but why would it be when a higher privacy level is organizational and it seems appropriate for organizational data. The name says it all.

upvoted 1 times

...

Chk88

2 years, 5 months ago

Answer correct, data type

upvoted 2 times

...

nbagchi

2 years, 6 months ago

I would have selected the same

upvoted 4 times

...