PL-300 Visualize and analyze the data Practice Test 4 — 15 Questions

Question 1

You have a Power BI report that uses a bar chart to show sales by region. Users report that the chart is difficult to read because many regions have similar sales values. You need to improve the readability without changing the data. Which visual should you use?

Accepted Answer

Small multiples (bar chart). Option B is correct because a small multiples chart allows breaking down the bar chart into separate panels per region, making it easier to compare values. Option A is wrong because treemaps are not ideal for comparing similar values. Option C is wrong because line charts are for trends. Option D is wrong because donut charts show proportions.

Answer

Line chart

Answer

Treemap

Answer

Donut chart

Question 2

You are designing a Power BI report for executives. They need to quickly see the top 10 products by revenue and the trend of revenue over the last 12 months. Which combination of visuals should you include on a single page?

Accepted Answer

Stacked bar chart for top products and a line chart for monthly revenue trend. Option C is correct because a stacked bar chart shows top products and a line chart shows trend. Option A is wrong because two bar charts are redundant. Option B is wrong because a table and pie chart are not ideal for trends. Option D is wrong because a funnel chart is for stages.

Answer

Clustered bar chart for top products and a stacked bar chart for monthly revenue

Answer

Funnel chart for top products and a line chart for monthly revenue

Answer

Table of products and a pie chart for monthly revenue

Question 3

Refer to the exhibit. You have a DAX measure that calculates year-over-year sales growth. When you add this measure to a table visual with Year and Month, some rows show blank values. What is the most likely cause?

Accepted Answer

The Calendar table does not have a continuous date range, causing SAMEPERIODLASTYEAR to return blank for some months. Option B is correct because SAMEPERIODLASTYEAR requires a contiguous date range; missing dates in the Calendar table cause blank returns. Option A is wrong because DIVIDE handles division by zero. Option C is wrong because the measure uses SUM, not a relationship issue. Option D is wrong because the measure works at month granularity.

Answer

The measure cannot be used at the month level because SAMEPERIODLASTYEAR only works at year level

Answer

The measure is trying to divide by zero for months with no sales in the previous year

Answer

The relationship between Sales and Calendar is inactive

Question 4

You have a Power BI report with a matrix visual showing sales by region and product category. You want to allow users to expand and collapse groups. Which feature should you enable?

Accepted Answer

Row and column subtotals. Option D is correct because row subtotals and column subtotals are enabled by default, but the matrix visual supports expand/collapse when the hierarchy is present. Option A is wrong because drill-down is different. Option B is wrong because drill-through navigates to another page. Option C is wrong because tooltips are for hover information.

Answer

Page tooltips

Answer

Drill-down mode

Answer

Drill-through

Question 5

You are building a Power BI report that uses a live connection to an Azure Analysis Services (AAS) tabular model. Users need to be able to filter data using a slicer that shows only products that have been sold in the current year. What should you do?

Accepted Answer

Create a calculated table in the AAS model that returns only products sold in the current year. Option C is correct because a calculated table in the AAS model can filter products dynamically, and it will be available in the live connection. Option A is wrong because live connections do not allow new calculated tables in Power BI Desktop. Option B is wrong because a calculated column in the view filters the entire table, not just the slicer. Option D is wrong because the filter pane applies to all visuals, not just the slicer.

Answer

Add a calculated column to the Product table in the AAS model that marks products sold this year

Answer

Use a filter on the slicer visual to show only products where sales year equals current year

Answer

Create a calculated table in Power BI Desktop using DAX to filter products

Question 6

Refer to the exhibit. You have a JSON definition of a Power BI dataset. You need to ensure that when a user filters by Product[Category], the filters propagate to Sales table. What is the current cross-filtering behavior?

Accepted Answer

Filter from Product flows to Sales. Option A is correct because 'oneDirection' means filter flows from the 'one' side (Product) to the 'many' side (Sales). Option B is wrong because 'bothDirections' is not set. Option C is wrong because the filter does propagate. Option D is wrong because the behavior is defined.

Answer

Filter from Sales flows to Product

Answer

No filter propagation occurs

Answer

Filter propagation is bidirectional

Question 7

You have a Power BI report that uses a map visual to show store locations. Some stores have the same latitude and longitude. You want to distinguish overlapping points. Which visual feature should you use?

Accepted Answer

Bubble map with bubble size set to a measure. Option B is correct because the bubble map with size can differentiate overlapping points by a measure. Option A is wrong because a shape map shows regions. Option C is wrong because a filled map shows regions. Option D is wrong because arcGIS map may have similar issues.

Answer

ArcGIS map

Answer

Filled map

Answer

Shape map

Question 8

You are creating a Power BI report that includes a scatter chart with many data points. Users want to identify outliers quickly. Which approach should you recommend?

Accepted Answer

Add a trend line to the scatter chart and use analytics pane to highlight outliers. Option C is correct because adding a trend line and highlighting outliers helps identify them. Option A is wrong because a table is not visual. Option B is wrong because a line chart is for trends. Option D is wrong because a histogram shows distribution, not outliers individually.

Answer

Use a line chart to see spikes

Answer

Add a table with conditional formatting to show high values

Answer

Convert to a histogram to see distribution

Question 9

Refer to the exhibit. You have a DAX measure that ranks products by sales amount. When you add this measure to a table visual with ProductID and Sales Amount, you notice that the rank resets for each year when you add a Year slicer. What should you modify to ensure ranking is always across all products regardless of slicer?

Accepted Answer

Change ALL to ALL(Sales) and add a filter to ignore year. Option A is correct because ALL removes all filters, but if you want to ignore the year slicer, you need to use ALLSELECTED or modify to ALL(Product[ProductID]) but also use ALL to ignore year filter. Option B is wrong because ALLSELECTED respects slicer selection. Option C is wrong because VALUES respects filters. Option D is wrong because ALLNOBLANKROW is similar to ALL.

Answer

Change ALL to ALLSELECTED(Sales[ProductID])

Answer

Change ALL to ALLEXCEPT(Sales, Sales[Year])

Answer

Change ALL to VALUES(Sales[ProductID])

Question 10

You are designing a Power BI report page. Which two actions can you take to improve the accessibility of the report?

Accepted Answer

Add data labels to visuals. Options B and D are correct. Option A is wrong because high contrast can be achieved via themes, not just dark background. Option C is wrong because tooltips are not required. Option E is wrong because images should have alt text.

Answer

Use a dark background with light text

Answer

Avoid using images in visuals

Answer

Remove all tooltips to reduce clutter

Question 11

You have a Power BI report that uses a custom visual from AppSource. The visual is not rendering correctly. Which three steps should you take to troubleshoot?

Accepted Answer

Check if the visual version is compatible with your Power BI Desktop version. Options A, C, and D are correct. Option B is wrong because clearing cache might not fix visual rendering. Option E is wrong because disabling hardware acceleration is a general troubleshooting step but not specific to custom visuals.

Answer

Disable hardware acceleration in Power BI Desktop

Answer

Clear the browser cache

Question 12

You are creating a Power BI report that uses a composite model with DirectQuery and imported tables. Which two considerations should you keep in mind?

Accepted Answer

Some DAX functions may have limitations when used across storage modes. Option A is correct because in a composite model, DAX functions that require data to be in-memory (like time intelligence functions) may not work correctly when referencing DirectQuery tables, as those tables remain in the source database. Additionally, certain DAX functions (e.g., `DISTINCTCOUNT`, `VALUES`) can behave differently or have restrictions when used across storage modes, such as returning limited results or requiring specific filter contexts.

Answer

Relationships can only be defined between tables of the same storage mode

Answer

DirectQuery tables cannot be related to imported tables

Answer

All measures must be created in the imported tables

Question 13

You have a Power BI report that includes a line chart showing monthly sales. You want to add a forecast for the next six months. Which feature should you use?

Accepted Answer

Analytics pane. The Analytics pane in Power BI provides built-in forecasting capabilities for time-series data. By selecting a line chart and adding a forecast from the Analytics pane, you can configure the forecast length (e.g., six months), confidence intervals, and seasonality, enabling predictive analysis directly within the visual.

Answer

Filter pane

Answer

Format pane

Answer

Visualization pane

Question 14

You are designing a Power BI report for a sales team. They need to see their individual performance compared to team averages. You have a table with columns: Salesperson, Region, SalesAmount. Which visual best allows each salesperson to see their own value alongside the average?

Accepted Answer

Combo chart (clustered column and line) with salesperson bars and average line. Option B is correct because a combo chart can show individual bars and a line for average. Option A is wrong because a table with conditional formatting doesn't show average easily. Option C is wrong because a clustered bar chart can show average but not as clearly. Option D is wrong because a waterfall chart is for cumulative changes.

Answer

Clustered bar chart with a measure for average

Answer

Waterfall chart

Answer

Table with conditional formatting

Question 15

Refer to the exhibit. You have a DAX measure that calculates customer lifetime value (CLV) as total revenue divided by distinct customer count. When you use this measure in a visual with Product category, you notice that the CLV values are higher than expected. What is the most likely reason?

Accepted Answer

The measure counts customers per category, but customers who buy multiple categories are counted in each category, reducing the denominator. Option C is correct because DISTINCTCOUNT(Sales[CustomerID]) counts customers who purchased any product in that category, but if a customer bought multiple products in the same category, they are counted once. However, the issue is that the denominator is smaller because customers who bought multiple categories are counted in each category, leading to higher CLV. Option A is wrong because DIVIDE handles zeros. Option B is wrong because the measure is correct syntactically. Option D is wrong because the measure doesn't consider customer-level profitability.

Answer

The measure does not filter out returns

Answer

The measure should use COUNTROWS instead of DISTINCTCOUNT

Answer

The measure is dividing by zero for categories with no customers