nerdexam
Microsoft

DP-500 · Question #22

You are building a Power BI dataset that will use two data sources. The dataset has a query that uses a web data source. The web data source uses anonymous authentication. You need to ensure that…

The correct answer is A. Public. To allow a web data source with anonymous authentication to be used by all other queries in a Power BI dataset, the privacy level should be set to Public.

Query and transform data

Question

You are building a Power BI dataset that will use two data sources. The dataset has a query that uses a web data source. The web data source uses anonymous authentication. You need to ensure that the query can be used by all the other queries in the dataset. Which privacy level should you select for the data source?

Exhibit

DP-500 question #22 exhibit

Options

  • APublic
  • BOrganizational
  • CPrivate
  • DNone

How the community answered

(29 responses)
  • A
    93% (27)
  • B
    3% (1)
  • C
    3% (1)

Why each option

To allow a web data source with anonymous authentication to be used by all other queries in a Power BI dataset, the privacy level should be set to Public.

APublicCorrect

The 'Public' privacy level is appropriate for data sources that do not contain or transmit sensitive information, such as publicly available web data accessed with anonymous authentication. Setting it to Public allows it to be combined with data from other privacy levels without compromising data isolation.

BOrganizational

'Organizational' privacy level is for internal data sources that can be shared within the organization but might not be suitable for combination with public data due to potential privacy firewall issues if not configured carefully.

CPrivate

'Private' privacy level is for highly sensitive or isolated data sources that should not be combined with other data sources, as it restricts data mashup capabilities and may prevent the query from being used by other queries.

DNone

'None' is not a valid privacy level option in Power BI's data source settings.

Concept tested: Power BI data privacy levels and data mashup

Source: https://learn.microsoft.com/en-us/power-query/privacy-levels

Topics

#Power Query Privacy Levels#Data Source Configuration#Data Blending

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice