PL-300 Visualize and analyze the data Practice Question
You are designing a Power BI report for a sales team. The team needs to see revenue by product category, but also want to view daily trends for a selected product. The data has over 10 million rows. What visual design approach minimizes report load time?
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
✓
Create a drillthrough page with a line chart showing daily revenue, and use category page as source
Option D is correct because a drillthrough page keeps the main category page lightweight and only loads the daily revenue line chart when a user right-clicks a product and drills through, so the 10 million-row detail query runs on demand rather than on every page render. This design also lets the drillthrough page be filtered to the selected product, reducing the data volume processed by the line chart. Options A and C are wrong because rendering both category and daily-trend visuals on one page forces all queries, including the high-cardinality daily aggregation, to execute on initial load. Option B is wrong because bookmarks only toggle visual visibility on the same page; hidden visuals and their underlying queries can still be evaluated, so it does not reliably reduce load time.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a custom visual that combines both views in one chart
Why it's wrong here
A custom visual that blends category and trend views into a single chart still requires the full underlying dataset to be loaded into the visual's data view at render time. Because custom visuals often perform client-side aggregation and lack the built-in query optimizations of native Power BI visuals, they can actually increase memory and CPU overhead. This approach does not defer or reduce the initial data load, so it does not address the goal of minimizing report startup time.
- ✗
Use bookmarks to switch between category view and daily trend view
Why it's wrong here
Bookmarks only alter visual visibility and page navigation after all visuals have already been loaded into memory; they have no effect on initial query execution. When a report page contains both the category and trend visuals, Power BI still processes every visual's data at open time, regardless of whether a bookmark hides it later. Thus, bookmark toggling does not reduce the data volume loaded and cannot substitute for true deferred loading such as a drillthrough page.
- ✗
Place a stacked column chart showing all categories and a line chart for trend on the same page
Why it's wrong here
Placing a stacked column chart and a line chart on the same report page forces Power BI to instantiate and render both visuals during the initial page load. Even though they may share a common data source, each visual independently requests and holds its aggregation of the dataset, doubling client-side rendering work and increasing the memory footprint. This strategy worsens, rather than improves, the initial load performance for the sales team.
- ✓
Create a drillthrough page with a line chart showing daily revenue, and use category page as source
Why this is correct
A drillthrough page is lazy-loaded by Power BI, meaning the daily revenue line chart is not instantiated or queried until a user explicitly right-clicks a data point on the category page and selects the drillthrough target. The source category page remains the only visual rendered upfront, so the detailed trend data is deferred until the exact moment of interaction. This reduces the report's initial load time and is the recommended pattern for on-demand detail exploration in PL-300 performance optimization.
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.