A logistics company wants to show the geographic distribution of delivery delays across different cities. The data includes city names, delay counts, and average delay hours. Users need to see the severity of delays at a glance. Which visual should you use?

A pie chart showing the proportion of delays by city.

A bar chart with city names on the axis and delay count on the value axis.

A map visual with bubble size representing delay count and color representing average delay hours.

A table with city names, delay counts, and average delay hours.

An analyst is building a new report page and wants Copilot to suggest which visuals to include based on the dataset. The analyst wants to accept the suggestions and then adjust the layout. What should the analyst do?

Use Copilot to write DAX measures, then add visuals manually.

Use Copilot to suggest content for the page, then drag and drop the suggested visuals onto the canvas.

Manually select visuals from the Visualizations pane and add them to the page.

Use Copilot to create the page, which automatically adds suggested visuals, then adjust the layout.

You are designing a report page that will be used by executives on large monitors. The page has a KPI card, a line chart, and a map. You want to ensure that the visuals are arranged to make the most important information prominent. What should you do?

Place all visuals in a single column to keep the page simple.

Place the KPI card at the top, the line chart in the center, and the map on the right, and use consistent spacing.

Use the mobile layout view to arrange the visuals for the large monitor.

Place the map at the top, the line chart in the center, and the KPI card at the bottom.

You have a matrix visual showing sales by product category and year. You need to add a column that shows the percentage of the row total for each cell, but you are NOT allowed to modify the data model. What is the best way to achieve this?

Create a measure using DAX, such as 'DIVIDE(SUM(Sales), CALCULATE(SUM(Sales), ALLSELECTED()))'.

Use conditional formatting to show the percentage as a data bar.

Create a calculated column in the data model that computes the percentage.

Use a visual calculation with DAX, such as 'DIVIDE(Sales, ROW_TOTAL(Sales))'.

Microsoft Certified:Power BI Data Analyst Associate

Domain 3Objective 1

Create Reports PL-300 Practice Questions (Page 3)

Part of the Visualize and analyze the data domain, which accounts for 25–30% of the PL-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~10–20 in this domain), expect 3–7 from this objective — we provide 47 practice questions to prepare you well beyond it. (estimate)

47questions here

10free pages

11concepts

25–30%of the exam

Questions 11–15

11application · medium
A logistics company wants to show the geographic distribution of delivery delays across different cities. The data includes city names, delay counts, and average delay hours. Users need to see the severity of delays at a glance. Which visual should you use?
Select an answer first
12application · medium
An analyst is building a new report page and wants Copilot to suggest which visuals to include based on the dataset. The analyst wants to accept the suggestions and then adjust the layout. What should the analyst do?
Select an answer first
13application · medium
You are designing a report page that will be used by executives on large monitors. The page has a KPI card, a line chart, and a map. You want to ensure that the visuals are arranged to make the most important information prominent. What should you do?
Select an answer first
14foundation · easy
A report author wants to automatically color cells in a table red when the sales value is below a certain threshold. Which feature should be used?
Select an answer first
15expert · hard
You have a matrix visual showing sales by product category and year. You need to add a column that shows the percentage of the row total for each cell, but you are NOT allowed to modify the data model. What is the best way to achieve this?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PL-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “PL-300” is a trademark of its owner, used for identification only.