PL-300 Prepare the data Practice Question
Exhibit
Refer to the exhibit.
{
"dataSources": [
{
"name": "SalesData",
"connectionDetails": {
"server": "myserver.database.windows.net",
"database": "SalesDB",
"authenticationKind": "UsernamePassword",
"encryptedConnection": "Encrypted",
"privacyLevel": "Private"
}
}
]
}You are reviewing a Power BI data source configuration JSON. The exhibit shows a data source definition. What is the privacy level setting for the data source 'SalesData'?
⚠ Common exam trap
Candidates often confuse the 'Private' privacy level with the 'Organizational' level, thinking that data within the same organization is automatically safe to combine, but the JSON explicitly shows 'Private', which is the most restrictive setting.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Private
The privacy level setting for the data source 'SalesData' is 'Private' because the JSON snippet shows the property "privacyLevel":"Private". In Power BI, the Private privacy level restricts data from being combined with data from other sources, ensuring that sensitive data is not inadvertently shared across queries. This setting is explicitly defined in the data source configuration and is not Organizational, None, or Public.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Organizational
Why it's wrong here
The Organizational privacy level in Power BI permits data sharing among users within the same trusted tenant, but only when the source's configuration explicitly sets privacyLevel to Organizational. In the provided JSON, the stanza reads "privacyLevel": "Private", which directly contradicts any Organizational classification. Reading the literal key-value pair is mandatory because Power Query uses that exact token to enforce isolation rules; assuming Organizational would disregard the serialized value and misrepresent the data gateway's security posture.
- ✓
Private
Why this is correct
The JSON explicitly declares "privacyLevel": "Private", so the correct answer is Private. This level tells Power Query that the source contains sensitive or confidential data, causing it to partition and rewrite queries so that no rows or columns from this source are mixed into other data sources without permission. It is the most restrictive privacy level and exactly matches the token present in the configuration file, making it the only factually defensible choice.
- ✗
None
Why it's wrong here
The None privacy level, if it were valid in modern Power BI, would indicate that privacy checks are ignored, allowing unfettered data combination across sources. However, the configuration in question does not omit or default the property; it includes an explicit assignment to "Private". Since None cannot be reverse-engineered from the JSON and would require assuming an absence of enforcement, it is demonstrably incorrect. Modern Power BI no longer surfaces None as a selectable option, so this answer also conflicts with current product behavior.
- ✗
Public
Why it's wrong here
Public privacy level would classify the data as intentionally shareable with no restrictions, enabling Power Query to freely combine this source with any other public or organizational source. The JSON, however, explicitly overrides that by setting "privacyLevel": "Private", which imposes the opposite constraint—data must remain isolated. Thus, selecting Public directly contradicts the serialized configuration, which is the canonical source of truth for a data source defined in Power BI.
Go deeper
Related to this question
About these practice questions
This PL-300 question is part of Courseiva's 524-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.