PL-300 Manage and secure Power BI Practice Question
Your organization is deploying Power BI content to multiple stages (dev, test, prod) using deployment pipelines. You need to ensure that test data is not visible to production users. What is the best approach?
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
✓
Use deployment pipelines with separate datasets per stage and configure data source parameters to point to different databases.
Option D is correct because deployment pipelines support deployment rules that let you bind each stage's dataset to a different data source via parameters, so the production stage connects to the production database and never exposes test data. Configuring data source parameters per stage is the standard mechanism for environment-specific connections in Power BI deployment pipelines. Option A is wrong because manually swapping datasets after deployment is error-prone and not a pipeline feature. Option B is wrong because row-level security filters rows for users, not test versus production data sources, and would still leave test data in the production dataset. Option C is wrong because separate tenants per stage is an extreme, costly approach that deployment pipelines are specifically designed to avoid.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Manually replace the dataset in the production workspace after deployment.
Why it's wrong here
Manually replacing the dataset in the production workspace after deployment is error-prone because it relies on a human to remember every step—publishing, overwriting, and verifying—which can easily corrupt reports or cause downtime during the original dataset refresh. It also bypasses version control and audit trails, so you lose the ability to roll back or trace who changed what, and it does not scale when managing multiple environments or frequent releases.
- ✗
Apply row-level security to filter test data in production.
Why it's wrong here
Row-level security (RLS) only restricts which rows a user can see based on role filters; it does not change the underlying data source or isolate a separate test database. Applying RLS to filter test data would still leave test records physically present in the production dataset, mixing them with live data and creating integrity and confidentiality risks, while doing nothing to address environment-specific connection strings or refresh schedules.
- ✗
Create separate Power BI tenants for each stage.
Why it's wrong here
Creating separate Power BI tenants for each stage is infeasible for most organizations because each tenant requires its own Microsoft Entra ID directory, global admin, and separate Power BI Premium capacity, multiplying licensing and administrative costs. It also eliminates any possibility of reusing shared artifacts like custom visuals or app workspaces across stages, complicating lifecycle management without providing the automated content deployment capabilities found in deployment pipelines.
- ✓
Use deployment pipelines with separate datasets per stage and configure data source parameters to point to different databases.
Why this is correct
Using deployment pipelines with separate datasets per stage and configuring data source parameters to point to different databases is the correct approach because it automates the propagation of reports, dashboards, and datasets across environments while preserving the separation of data at each stage. By defining parameters for the server and database in Power Query, you can deploy the same report package but repoint each stage to its own database, ensuring test and QA workloads never hit production data and enabling safe validation before final release.
Go deeper
Related to this question
About these practice questions
One of 524 original PL-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.