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

Question 1

You want to create a visual that shows the top 5 products by sales amount, but also want to include an 'Other' category that aggregates all remaining products. Which approach should you use?

Accepted Answer

Use the 'Group' feature on the product field and select 'Include Other'. Use the 'Group' feature on the product field and select 'Include Other'. In Power BI, the grouping (list) feature lets you bucket the top items and automatically rolls all remaining values into an 'Other' group, which is exactly the requirement to show top 5 products plus an aggregated 'Other' category. Option A does not work because a slicer only filters existing values and cannot synthesize an 'Other' aggregate. Option B is impractical since a calculated column cannot dynamically determine the top 5 by sales measure and would not aggregate the remainder correctly. Option C fails because a Top N filter excludes the remaining products rather than aggregating them into an 'Other' measure.

Answer

Add a slicer to filter top 5 and manually add 'Other'

Answer

Create a calculated column that assigns 'Other' to non-top-5 products

Answer

Apply a Top N filter and add a measure for 'Other'

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. 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 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.. 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 4

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.. 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 5

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. Static row-level security in Power BI Desktop (option D) is correct because it lets you define roles in the modeling layer and assign fixed DAX filter rules (for example, [Region] = "West") to those roles, which the Power BI service then enforces per user. DAX filter expressions in roles (option E) is correct because RLS is implemented precisely by writing DAX table filter expressions such as [SalesTerritory] = LOOKUPVALUE(...) or USERPRINCIPALNAME() within each role, and this is the mechanism that actually filters rows for the signed-in user. Bookmarks that hide rows (option A) only change visual visibility and do not secure the underlying data, so users could still access hidden values through other visuals or exports. Report-level filters (option B) apply the same filter to everyone viewing the report and are not user-specific, so they cannot enforce per-user row security. A slicer with user principal name (option C) is just a report interaction and does not restrict data at the model level, so it is not an RLS implementation.

Answer

Bookmarks that hide rows

Answer

Report-level filters

Answer

Slicer with user principal name

Question 6

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. None of the provided visuals are ideal for showing sales trends over time with drill-down. The correct visual should be a line chart or column chart with drill-down enabled. The Decomposition Tree is used for root cause analysis, not time series trends. The Pie chart shows proportions, the Scatter chart shows correlations, and the Gauge shows a single value against a target.

Answer

Pie chart

Answer

Scatter chart

Answer

Gauge

Question 7

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 8

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

Question 9

Your Power BI report uses a custom visual that is not rendering in the Power BI service. The visual works correctly in Power BI Desktop. What is the most likely cause?

Accepted Answer

The custom visual is not certified by Microsoft. Custom visuals from AppSource require approval; if not certified, they may be blocked by admin policies. The data source is irrelevant, and all visuals need to be loaded. Refreshing the browser rarely helps.

Answer

The data source is not supported in the service

Answer

The visual was not imported into the report

Answer

The browser needs to be refreshed

Question 10

Refer to the exhibit. You are configuring a Power BI dataset for a real-time dashboard that must show data with no more than 5 minutes of latency. What is the impact of the current query caching setting?

Accepted Answer

It will improve performance but may show data up to 60 minutes old. Query caching stores results for up to 60 minutes, causing data to be up to an hour old. This violates the 5-minute latency requirement. The mode is On, not off, and caching applies to all queries. DirectQuery mode does not eliminate caching.

Answer

It will disable caching for real-time queries

Answer

It will cause the dataset to switch to DirectQuery mode

Answer

It will have no effect because caching is off

Question 11

Refer to the exhibit. You run this DAX query and receive an error. What is the most likely reason?

Accepted Answer

SUMMARIZECOLUMNS requires a measure, not an aggregation expression. SUMMARIZECOLUMNS cannot use SUM directly; it requires an explicit filter context or a measure. A measure should be defined first or use CALCULATE. The syntax is correct but the expression is invalid.

Answer

The column 'Category' does not exist

Answer

SUMMARIZECOLUMNS is deprecated

Answer

EVALUATE cannot be used in DAX queries

Question 12

Which THREE features can be used to create custom narratives in Power BI? (Choose three.)

Accepted Answer

Calculated columns. Calculated columns (A) are correct because they let you add new row-level fields to a table using DAX, which can be surfaced in reports to build a tailored, custom narrative around your data rather than relying only on the raw source columns. DAX measures (B) are correct because they compute dynamic aggregations and KPIs at query time, enabling you to craft custom narrative text and visuals that respond to filter context. Custom visuals from AppSource (C) are correct because importing third-party or organization-specific visuals lets you present data in bespoke formats that support a custom narrative beyond the built-in visuals. Smart Narratives (D) is not among the marked answers because it is a built-in visual that auto-generates narrative text rather than a feature for creating custom narratives. Bookmarks (E) is not marked because it captures and replays report state (filters, slicers, visibility) and does not itself create custom narrative content.

Answer

Smart Narratives visual

Answer

Bookmarks

Question 13

Refer to the exhibit. You configure incremental refresh for a Power BI dataset with the above policy. The dataset contains 3 years of historical data. How will the rolling window affect the data?

Accepted Answer

Only the most recent 10 days will be refreshed. The rolling window of 10 days means only the last 10 days are refreshed incrementally. Historical data beyond 30 days is not refreshed unless a full refresh occurs. The mode 'merge' does not affect this.

Answer

Data older than 30 days will be merged into the history

Answer

All data older than 30 days will be removed

Answer

The entire dataset will be refreshed every 10 days

Question 14

Refer to the exhibit. You run this DAX query but the YoY Growth column returns blank for all rows. What is the most likely cause?

Accepted Answer

Local measures cannot be referenced by other local measures in SUMMARIZECOLUMNS. The 'Total Sales' measure is defined locally (DEFINE), but SUMMARIZECOLUMNS may not evaluate local measures in the same context. The measure reference [Total Sales] inside SUMMARIZECOLUMNS might not resolve correctly. Moving the measure definition to the model would fix it.

Answer

The subtraction operator does not work with measures

Answer

SAMEPERIODLASTYEAR requires a continuous date range

Answer

The 'Date' table has no relationship with Sales

Question 15

A user wants to see the top 10 products by sales but also include a total row at the bottom of the table. How can you achieve this?

Accepted Answer

Enable the total row in the formatting pane of the table visual. The correct answer is D: enabling the total row in the formatting pane of the table visual, because a table visual in Power BI has a built-in Totals section where you can toggle the total row on, which automatically aggregates the displayed values at the bottom of the table while still showing the top 10 products. This directly satisfies the requirement of showing the top 10 products plus a total row within the same visual. Option A is incorrect because a Top N filter limits rows but does not itself add a total row, and a separate measure would not render as a row in the table. Option B is unrelated, as 'Show items with no data' only displays categories lacking values and does not create totals. Option C is wrong because a separate card visual places the total outside the table rather than as a total row at the bottom of the table.

Answer

Apply a Top N filter to the visual and add a measure for total

Answer

Use the 'Show items with no data' option

Answer

Create a separate card visual for total sales