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

Question 1

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?

Choose an answer to begin — your selection is scored in the full session.

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 2

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 3

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. The matrix visual is designed for hierarchical data and supports expand/collapse to navigate between year, quarter, and month levels. Option A (table visual) does not have built-in expand/collapse; it is flat. Option B (stacked bar chart with drill-down) allows drilling to different levels but does not provide the expand/collapse interaction within the same visual. Option D (card visual) shows a single value and cannot represent hierarchy.

Answer

Table visual with hierarchy

Answer

Stacked bar chart with drill-down

Answer

Card visual with hierarchy

Question 4

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 D and E are correct. Option D, static row-level security in Power BI Desktop, allows defining roles and filters applied based on user identity. Option E, DAX filter expressions in roles, is the primary method for implementing RLS using logical conditions. Option A is incorrect because bookmarks only capture visual state, not security; they cannot hide rows from specific users. Option B is incorrect because report-level filters apply to all users uniformly and do not restrict data per user. Option C is incorrect because a slicer with user principal name only filters visuals based on the selected value but does not enforce security; any user can change the slicer selection.

Answer

Bookmarks that hide rows

Answer

Report-level filters

Answer

Slicer with user principal name

Question 5

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 B, D, and E are correct. Reducing the number of visuals on a page decreases rendering load and improves report performance. Using pre-aggregated data (e.g., summary tables) reduces the amount of data processed by Power BI. Disabling cross-highlighting and cross-filtering when not needed reduces query overhead. Option A is incorrect because measures are generally more efficient than calculated columns for aggregations; calculated columns are calculated during refresh and stored in memory. Option C is incorrect because importing unnecessary columns increases model size and refresh time; only import columns that are actually needed.

Answer

Use calculated columns instead of measures for complex aggregations.

Answer

Import all columns from source tables to avoid missing data.

Question 6

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

Accepted Answer

100% stacked bar chart. The correct answers are B and E. A 100% stacked bar chart (B) shows each category's proportion as a percentage of the whole, making it suitable for comparing parts of a whole. A pie chart (E) directly displays proportions of a whole as slices. Option A (Waterfall chart) is used for cumulative changes, not proportions. Option C (Scatter plot) shows relationships between variables. Option D (Line chart) shows trends over time.

Answer

Waterfall chart

Answer

Scatter plot

Answer

Line chart

Question 7

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'.. A relative date filter on the date field set to 'Last 12 months' automatically filters the visual to show data from the last 12 complete months based on the current date, which is dynamic and meets the requirement. Option A is incorrect because a calculated column is static and does not update automatically as new data is loaded; it would require manual recalculation. Option B is incorrect because a slicer would require the user to manually select each month, which is not efficient for a dynamic time period. Option C is incorrect because a measure can calculate sales for the last 12 months, but a measure alone does not filter the visual; you still need to apply a filter on the date field to restrict the date range.

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 8

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.. Live connections in Power BI do not support adding calculated columns or measures directly in the report; they must be created in the source dataset. Option A is incorrect because row-level security (RLS) does not prevent calculated columns; in fact, RLS is fully supported with live connections. Option B is incorrect because table visuals are fully supported with live connections. Option C is incorrect because there is no 'Allow calculations' setting; the limitation is inherent to live connections.

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 9

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 10

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 11

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 12

You need to create a visual that shows the relationship between advertising spend and website traffic. Which type of visual is most appropriate?

Accepted Answer

Scatter chart. Scatter charts are ideal for showing relationships between two numeric variables. A line chart shows trends over time, a bar chart compares categories, and a pie chart shows proportions.

Answer

Stacked bar chart

Answer

Pie chart

Answer

Line chart

Question 13

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 14

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 15

You want to allow users to highlight different product categories in a line chart by selecting from a list. Which feature should you add?

Accepted Answer

Slicer. A slicer filters or highlights data based on selection, making it ideal for category selection. Bookmarks save a state, drillthrough navigates to another page, and tooltips show details on hover.

Answer

Tooltip

Answer

Bookmarks

Answer

Drillthrough