PL-300 Deploy and maintain assets Practice Question
You have developed a Power BI report that uses a live connection to an Azure Analysis Services (AAS) model. The AAS model is deployed in a different Azure region. Users report that the report loads slowly, sometimes taking over 30 seconds to render a single visual. You need to improve performance without changing the data model or the report structure. What should you do?
⚠ Common exam trap
A common mix-up: candidates confuse client-side optimization settings (like reducing data shown) with server-side performance fixes, or they incorrectly assume that adding RLS or switching to import mode are acceptable solutions when the question explicitly prohibits changing the data model or report structure.
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
✓
Deploy the Azure Analysis Services model to the same region as the Power BI workspace.
Deploying the Azure Analysis Services model to the same Azure region as the Power BI workspace minimizes network latency between the live connection client (Power BI) and the tabular model server. A live connection sends DAX queries over the XMLA protocol, and cross-region traffic introduces significant round-trip delays, which directly causes slow visual rendering. By co-locating the AAS server and the Power BI service in the same region, you reduce the physical distance and network hops, improving query response time without altering the model or report.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Enable the 'Reduce data shown in visuals' option in Power BI Desktop.
Why it's wrong here
This client-side option limits the number of data points rendered per visual (e.g., to the top 10), but Power BI still submits the original DAX query to Azure Analysis Services, so the full aggregation and processing load remains on the model. It reduces visual rendering time and bandwidth for chart images, but does nothing to reduce the query execution cost on AAS or the network latency of the live connection. In fact, it can mask performance issues rather than address their root cause.
- ✗
Implement row-level security (RLS) in the Azure Analysis Services model.
Why it's wrong here
RLS in Azure Analysis Services enforces user-level filters by appending predicates to every DAX query, which adds extra evaluation overhead rather than reducing it. It is purely an access-control mechanism that restricts which rows are returned, not a performance optimization; the same measure calculations and aggregations still run in the model. With complex role definitions, RLS can actually increase query execution time due to additional filter logic.
- ✓
Deploy the Azure Analysis Services model to the same region as the Power BI workspace.
Why this is correct
A live connection means each Power BI visual executes a DAX query through the network to the Analysis Services instance, so physical distance directly affects response time. By co-locating the AAS server and the Power BI workspace in the same Azure region, round-trip network latency is minimized and data can stay within a single data center, which yields the fastest live query performance. This is a low-effort architectural fix that reduces latency without adding any per-query overhead or altering data granularity.
- ✗
Convert the report to import mode and schedule a refresh.
Why it's wrong here
Converting to import mode replaces the live connection with a local copy of the data in Power BI's VertiPaq engine, which would require configuring a gateway and scheduled refreshes to keep that copy current. This is a fundamentally different architecture that sacrifices real-time access to the AAS model, potentially breaking row-level security and other model-based features. It also does not improve the live-connection performance issue — it eliminates the live connection entirely, which may not be acceptable for the reporting requirement.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-300 question from scratch — 217 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.