Microsoft
DP-500 · Question #108
You manage a dataset that contains the two data sources as shown in the following table. Data source Type of data Privacy level Azure SQL database Sensitive company data Private Microsoft SharePoint…
To resolve the privacy level error while maintaining the highest privacy possible, set both the Azure SQL database and the SharePoint folder to 'Organizational'. This allows data from sources with the same privacy level (Organizational) to be combined. The default 'Private'…
Implement and manage a data analytics environment
Question
You manage a dataset that contains the two data sources as shown in the following table.
Data source Type of data Privacy level
Azure SQL database Sensitive company data Private
Microsoft SharePoint folder Non-sensitive company data Private
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.
Exhibit
Explanation
To resolve the privacy level error while maintaining the highest privacy possible, set both the Azure SQL database and the SharePoint folder to 'Organizational'. This allows data from sources with the same privacy level (Organizational) to be combined. The default 'Private' setting generally prevents data combination with other sources.
Topics
#Data Privacy#Power Query#Data Firewall#Power BI Service
Community Discussion
No community discussion yet for this question.