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

Question 1

You have a Power BI report with the DAX measure shown in the exhibit. Users report that the measure returns blank for some months even though sales data exists for both current and previous years. What is the most likely cause?

Accepted Answer

The 'Date' table is not marked as a date table or is missing dates.. Option A is correct because SAMEPERIODLASTYEAR requires a contiguous date table marked as a date table; if the date table does not cover all dates, it may return blank. Option B is wrong because DIVIDE handles division by zero gracefully. Option C is wrong because the measure uses SUM which aggregates correctly. Option D is wrong because relationship direction affects filtering but not SAMEPERIODLASTYEAR's ability to shift dates.

Answer

The measure uses SUM instead of SUMX.

Answer

The DIVIDE function is incorrectly handling division by zero.

Answer

The relationship between 'Sales' and 'Date' is set to cross-filter direction single.

Question 2

You have a report page that shows sales by product category. You want to allow users to click on a category and see a detailed breakdown of products within that category on a separate page. Which Power BI feature should you implement?

Accepted Answer

Drillthrough page with category as a drillthrough field. Option B is correct because drillthrough allows passing a filter to another page. Option A is wrong because tooltips show on hover, not click. Option C is wrong because a slicer filters the same page. Option D is wrong because bookmarks navigate to a state, not filter another page.

Answer

Add a slicer for product category

Answer

Bookmark that shows the detail page

Answer

Report page tooltips

Question 3

You need to create a report that calculates running total of sales over time. Which Power BI feature should you use?

Accepted Answer

Use the Quick Measure for 'Running total'. Option C is correct because the Quick Measure for running total generates the appropriate DAX. Option A is wrong because a calculated column is static. Option B is wrong because a measure is needed but the quick measure provides correct formula. Option D is wrong because a calculated table is not needed.

Answer

Write a measure using SUM and FILTER

Answer

Create a calculated table with running total

Answer

Add a calculated column using EARLIER function

Question 4

You are reviewing a Power BI report with the JSON configuration shown in the exhibit. The visual is supposed to display the top 5 product categories by total sales, with all remaining categories grouped into 'Other'. However, the visual shows only the top 5 categories and no 'Other' bar. What is the most likely reason?

Accepted Answer

The 'otherGroup' section lacks a 'showOther' property set to true.. Option B is correct because the 'otherGroup' is defined but the aggregation of 'Other' must be enabled in the visual formatting; missing 'showOther' flag. Option A is wrong because JSON version 2.0 is valid. Option C is wrong because sorting does not affect grouping. Option D is wrong because the format is correct JSON.

Answer

The JSON version is incorrect; must be 3.0.

Answer

The 'sortOrder' should be 'ascending' for 'Other' to appear.

Answer

The JSON is malformed; missing closing bracket.

Question 5

You have a report with a map visual showing store locations. You want to display a tooltip with additional store information (e.g., manager name, phone number) when a user hovers over a point. How should you achieve this?

Accepted Answer

Create a report page tooltip and assign it to the map visual.. Option D is correct because a report page tooltip allows custom tooltip pages. Option A is wrong because a slicer does not provide tooltips. Option B is wrong because a card visual is separate. Option C is wrong because drillthrough navigates to another page.

Answer

Create a card visual next to the map and sync it with the map selection.

Answer

Add a slicer that displays the details when selected.

Answer

Set up a drillthrough page for each store.

Question 6

You need to design a report that allows users to see sales data at the year, quarter, and month levels, with the ability to expand and collapse hierarchies. Which visual type should you use?

Accepted Answer

Matrix visual. Option A is correct because matrix visual supports expand/collapse hierarchies. Option B is wrong because a bar chart does not have hierarchy expansion built-in. Option C is wrong because a table is flat. Option D is wrong because a card visual shows a single value.

Answer

Table visual with hierarchy

Answer

Stacked bar chart with drill-down

Answer

Card visual with hierarchy

Question 7

Which TWO features can be used to implement row-level security (RLS) in Power BI? (Select TWO.)

Accepted Answer

Static row-level security in Power BI Desktop. Options B and D are correct. Option A is wrong because report page filters apply to all users. Option C is wrong because a slicer does not enforce security. Option E is wrong because a bookmark does not enforce security.

Answer

Bookmarks that hide rows

Answer

Report-level filters

Answer

Slicer with user principal name

Question 8

Which THREE actions can help optimize a Power BI report's performance? (Select THREE.)

Accepted Answer

Reduce the number of visuals on a single page.. Options A, C, and D are correct. Option B is wrong because using many calculated columns can hurt performance. Option E is wrong because importing all columns increases model size and refresh time; only import needed columns.

Answer

Use calculated columns instead of measures for complex aggregations.

Answer

Import all columns from source tables to avoid missing data.

Question 9

Which TWO chart types are appropriate for comparing proportions of a whole? (Select TWO.)

Accepted Answer

100% stacked bar chart. Options A and D are correct. Option B is wrong because a line chart shows trends over time. Option C is wrong because a scatter plot shows correlation. Option E is wrong because a waterfall chart shows cumulative changes.

Answer

Waterfall chart

Answer

Scatter plot

Answer

Line chart

Question 10

You have a measure as shown in the exhibit. The sales amount is not accumulating correctly; instead, it shows the total sales for the selected date only. What is the problem?

Accepted Answer

The ALL('Date') function removes the filter context, so the calculation returns total sales for all dates.. Option B is correct because ALL('Date') removes all date filters, causing the CALCULATE to ignore the date filter context. Option A is wrong because VAR does not affect the result. Option C is wrong because relationship direction does not cause this specific issue. Option D is wrong because ALL does not cause circular dependency.

Answer

The measure should use ALLEXCEPT instead of ALL.

Answer

The VAR SelectedDate should be MIN instead of MAX.

Answer

The relationship between Sales and Date is inactive.

Question 11

You need to create a visual that displays the sales trend over the last 12 complete months. Which approach should you use?

Accepted Answer

Use a relative date filter on the date field set to 'Last 12 months'.. Option C is correct because a relative date filter on a date hierarchy shows the last N periods. Option A is wrong because a slicer requires manual selection. Option B is wrong because a calculated column is static. Option D is wrong because a measure alone does not filter visuals.

Answer

Create a calculated column that flags last 12 months.

Answer

Add a slicer for the last 12 months.

Answer

Write a measure that calculates sales for last 12 months and use it in a visual.

Question 12

You have a report that uses a live connection to a Power BI dataset. You want to add a table visual that shows sales by product, but you notice that you cannot add a calculated column. What is the reason?

Accepted Answer

Live connections do not support calculated columns; they must be created in the source dataset.. Option A is correct because live connections do not allow adding calculated columns; they must be created in the source dataset. Option B is wrong because table visuals are allowed. Option C is wrong because aggregations are possible. Option D is wrong because RLS is supported.

Answer

Live connections require row-level security which prevents calculated columns.

Answer

Table visuals are not supported with live connections.

Answer

You need to enable 'Allow calculations' in the dataset settings.

Question 13

You are creating a report in Power BI Desktop. You need to design a visual that shows sales trends over time and allows users to drill down from year to quarter to month. Which visual should you use?

Accepted Answer

Decomposition tree. The decomposed tree visual supports drill-down through hierarchies, making it suitable for trend analysis with drill-down. Options A and C are not ideal for time trends, and D is outdated.

Answer

Pie chart

Answer

Scatter chart

Answer

Gauge

Question 14

Your Power BI report includes a bar chart showing monthly sales. Users complain that the bars are too crowded when viewing a full year. What is the best design change to improve readability?

Accepted Answer

Add a slicer for quarter to filter the view. Sorting by sales value does not reduce crowding, changing to a line chart is better for continuous data, and removing axis labels harms readability. Slicing by quarter reduces the number of bars visible at once.

Answer

Sort the bars by sales value descending

Answer

Switch to a line chart

Answer

Remove the axis labels

Question 15

Refer to the exhibit. A user created this measure to calculate sales for the same period last year. However, the measure returns incorrect values when used in a matrix with month granularity. What is the most likely cause?

Accepted Answer

The 'Date' table is not marked as a date table. SAMEPERIODLASTYEAR relies on a contiguous date table; if the date table is not marked or has gaps, it may shift incorrectly. The DATE function is not the issue, and CALCULATE is used correctly. The time intelligence functions require a proper date table.

Answer

The DATE function is incorrectly specified

Answer

The VAR CurrentDate is not needed

Answer

CALCULATE should not be used with SAMEPERIODLASTYEAR

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

Exhibit

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

Exhibit