PL-300 Visualize and analyze the data Practice Questions

Free PL-300 Visualize and analyze the data practice test questions

8 questions from this domain with answers and explanations - different from the samples on the main PL-300 page. Sign up free to practice the full set.

1. Question 1Visualize and analyze the data

   You want users to ask natural language questions about the data directly within a report. Which Power BI visual should you add?

   • ADecomposition Tree
   • BKey Influencers visual
   • CQ&A visualCorrect
   • DSmart Narrative
   ✓ Correct answer: C

   The Q&A visual lets report consumers type natural-language questions directly on the report canvas and returns an auto-generated visual answer from the model. It is purpose-built for in-report natural language exploration. This makes it the correct visual when the goal is to let users ask questions about the data.

   Why the other options are wrong

   • AThe Decomposition Tree breaks a measure down across dimensions interactively but does not accept typed natural-language questions.
   • BThe Key Influencers visual explains which factors drive an outcome; it is not a natural-language question interface.
   • DSmart Narrative generates dynamic text summaries of visuals rather than answering user-typed questions.
2. Question 2Visualize and analyze the data

   Northwind Traders has a report with multiple pages. The analyst wants a slicer on the first page to filter visuals across all pages of the report. How should the analyst configure the slicer?

   • AEnable Sync Slicers and configure the slicer to sync across all pagesCorrect
   • BConvert the slicer to a bookmark
   • CAdd the slicer to the filter pane as a report-level filter
   • DCopy the slicer to each page manually
   ✓ Correct answer: A

   Sync Slicers is the built-in feature designed so a single slicer object can drive filtering on visuals across multiple report pages. Using the Sync Slicers pane, the author selects which pages the slicer applies to, and selections then flow to every synced page automatically. This keeps one slicer as the control surface rather than duplicating logic, and it maintains a live link so changes stay consistent everywhere. It directly satisfies filtering all pages from a slicer placed on the first page.

   Why the other options are wrong

   • BConverting the slicer to a bookmark captures a fixed report state to recall on demand and does not provide ongoing dynamic filtering as users change selections.
   • CAdding the field as a report-level filter would filter all pages but uses the Filters pane rather than the interactive slicer object the question requires.
   • DCopying the slicer onto each page leaves independent, unlinked slicers, so a selection on one would not update the others and the work must be repeated per page.
3. Question 3Visualize and analyze the data

   You want to create a custom tooltip that appears when users hover over data points in a chart. The tooltip should display a small chart showing the trend for that data point. How should you configure this?

   • AAdd a narrative visual to the tooltip settings
   • BUse conditional formatting to add a sparkline
   • CMake a page, set its type to Tooltip, add trendCorrect
   • DDrop the trend chart into the Tooltips field well
   ✓ Correct answer: C

   In Power BI, tooltip pages provide the mechanism for custom tooltips with rich visualizations. You create a separate report page and change its page type to "Tooltip" from the page formatting options. Add your trend chart to this tooltip page, and Power BI automatically displays it when users hover over data points in visuals that reference this tooltip page. This allows you to embed sophisticated custom visualizations within tooltip experiences without cluttering the main page.

   Why the other options are wrong

   • AAdding a narrative visual to the main chart's tooltip configuration is incorrect because the basic tooltip configuration does not support adding narrative or complex visuals directly.
   • BUsing conditional formatting to display a sparkline is incorrect because conditional formatting applies color rules to cells, not hoverable trend visualizations.
   • DAdding the trend chart to the Tooltips field well is incorrect because Power BI visuals do not have a "Tooltips" field well where you can add other visuals.
4. Question 4Visualize and analyze the dataSelect all that apply

   You are creating a dashboard in the Power BI service. Which TWO types of content can be pinned to a dashboard? (Choose two.)

   • AA DAX measure definition
   • BA visual from a reportCorrect
   • CA tile from another dashboardCorrect
   • DA Power Query step
   ✓ Correct answer: B, C

   Power BI dashboards are composed of tiles, which are snapshot containers of content pinned to the dashboard canvas. You can pin visuals directly from reports to a dashboard, creating interactive tiles that maintain the underlying report context. Additionally, you can pin entire tiles from existing dashboards to other dashboards, allowing dashboard consolidation and reuse. This two-way pinning capability enables flexible dashboard composition and the creation of summary dashboards that aggregate content from multiple sources.

   Why the other options are wrong

   • AA DAX measure definition is incorrect because measures exist within the semantic model and cannot be pinned as independent objects to a dashboard; only the results of measures displayed in visuals can be pinned.
   • DA Power Query step is incorrect because Power Query is a data transformation tool used during the data refresh process in Power BI Desktop, not a user-facing content type that can be pinned to a dashboard.
5. Question 5Visualize and analyze the data

   A finance team needs a pixel-perfect, multi-page invoice report that can be exported to PDF and printed. Each invoice must start on a new page. Which Power BI report type should the analyst use?

   • AA standard Power BI interactive report with page breaks enabled
   • BA Power BI dashboard with pinned tiles
   • CAn Excel export from the Power BI Service
   • DA paginated report authored in Power BI Report BuilderCorrect
   ✓ Correct answer: D

   Paginated reports are designed for pixel-perfect, print-ready output where layout, page breaks, and pagination are precisely controlled, which suits a multi-page invoice that must start each invoice on a new page and export cleanly to PDF. They are built in Power BI Report Builder using the RDL format. This is the report type intended for formatted, printable documents.

   Why the other options are wrong

   • AStandard interactive reports are optimized for on-screen exploration and do not guarantee pixel-perfect pagination or per-invoice page breaks.
   • BA dashboard with pinned tiles is a Service monitoring surface, not a printable multi-page document.
   • CAn Excel export produces a spreadsheet, not a formatted, paginated print-ready invoice.
6. Question 6Visualize and analyze the data

   Which best practice should be followed when managing Data within Visualize and Analyze the Data?

   • AGrant every team member Admin rights on all workspaces for convenience
   • BImplement role-based access control with least privilegeCorrect
   • CPublish semantic models to the organization so anyone can build on them
   • DHave the whole team share one semantic model owner account for edits
   ✓ Correct answer: B

   Implementing role-based access control (RBAC) with least privilege is a fundamental security best practice for managing data within Power BI. This approach ensures that team members have only the minimum permissions necessary to perform their duties, reducing the risk of unauthorized access, data breaches, and accidental modifications. By assigning roles based on job responsibilities, organizations can maintain data integrity while enabling efficient collaboration. This practice aligns with security compliance standards and industry regulations that emphasize the principle of least privilege.

   Why the other options are wrong

   • AGranting Admin rights on all workspaces exceeds job needs and violates the principle of least privilege.
   • CPublishing semantic models to the whole organization exposes them beyond the intended audience without controls.
   • DA shared owner account eliminates audit trails and makes it impossible to attribute actions to individuals.
7. Question 7Visualize and analyze the data

   When configuring bookmarks at Tailwind Traders, administrators must also consider visual-level filters as part of the overall architecture.

   • TrueTrueCorrect
   • FalseFalse
   ✓ Correct answer: True

   When implementing bookmarks in Power BI, visual-level filters are a critical architectural component that must be considered during configuration. Bookmarks capture the current state of a report page, including all filter selections and visual settings at that moment. Visual-level filters are integrated into this captured state, so administrators must account for them in their overall design strategy to ensure bookmarks function correctly across different user scenarios. Proper configuration ensures that bookmarks preserve the complete filtering context and deliver the intended user experience. Understanding this interdependency is essential for designing robust report navigation and filtering architectures.

   Why the other options are wrong

   • FalseFalse is incorrect. The statement is true. When implementing bookmarks in Power BI, visual-level filters are a critical architectural component that must be considered during configuration. Bookmarks capture the current state of a report page, including all filter selections and visual settings at that moment.
8. Question 8Visualize and analyze the data

   You apply background-color conditional formatting to a table's Profit Margin column using 'Color by rules'. The format pane shows percentages, but the rules evaluate against the raw decimal measure (e.g., 0.18). Some cells stay uncolored even though they exceed your 15% threshold. What is the BEST fix?

   • ADefine the rule bounds in the measure's underlying units (e.g., 0.15) rather than 15, or switch the summarization/number format so the rule and value scale matchCorrect
   • BSwitch the conditional formatting style from rules over to 'Color scale', because rule-based formatting is unable to read a measure and only a color scale can
   • CSet the rule's 'Based on field' selector to a separate text column instead of the profit margin measure, so the thresholds finally compare against matching values
   • DDisable cross-highlighting between the visuals on the page so that the conditional formatting rule can evaluate each cell correctly without interference
   ✓ Correct answer: A

   When 'Format by rules' is bound to a measure, the comparison uses the measure's raw value, so a margin stored as 0.18 must be tested against 0.15, not 15. Entering 15 makes every cell fall below the bound and stay uncolored. Aligning the rule's numeric bounds with the field's units, or formatting the measure as a percentage and using percentage bounds, resolves the mismatch.

   Why the other options are wrong

   • BRule-based formatting can read measures fine; the mismatch is scale, so switching to a color scale is unnecessary.
   • CBasing the rule on a text column cannot express a numeric 15% threshold and does not fix the scale mismatch.
   • DCross-highlighting does not affect how a formatting rule compares values, so disabling it changes nothing.

How Visualize and analyze the data is tested

This domain holds 176 of the 690 questions in the PL-300 bank, about 26%. The mix is 99 single-answer multiple choice, 42 multiple-response, 28 true/false, 4 ordering, 2 hotspot and 1 yes/no scenario, so it is worth practising the formats as well as the content.

Once you have a few attempts recorded, CertGrid scores every domain separately and points you at the weakest one, so you can drill Visualize and analyze the data on its own rather than re-running full-length mocks.

Other PL-300 exam domains

• Prepare the data193 questions
• Model the data186 questions
• Manage and secure Power BI135 questions
• All PL-300 practice questions690 total
• Visualize and analyze the data study notesKey concepts
• Microsoft practice examsAll Microsoft

PL-300 Visualize and analyze the data FAQ