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

Question 1

You are a data analyst for a retail company with stores across 50 states. You have a Power BI dataset that imports sales data from a SQL Server database daily. The fact table contains 200 million rows and includes columns: StoreID, ProductID, DateKey, SalesAmount, Quantity, and Discount. You also have dimension tables for Store, Product, and Date. Users report that a report page with a matrix visual showing SalesAmount by Store and ProductCategory takes over 30 seconds to render. You need to improve the performance of this visual without changing the data source or reducing the data granularity. You have the following options: A. Change the matrix visual to a table visual. B. Create an aggregation table on Store and ProductCategory with pre-calculated SalesAmount. C. Enable 'Show items with no data' on the matrix. D. Use a measure that sums SalesAmount and use the 'Filter' pane to restrict to top 100 rows. Which option should you choose?

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

Accepted Answer

Create an aggregation table on Store and ProductCategory with pre-calculated SalesAmount. Option C is correct because creating an aggregation table on Store and ProductCategory with pre-calculated SalesAmount reduces the number of rows Power BI must scan at query time, allowing the matrix visual to render much faster while preserving the required granularity and data source. Aggregations are a standard Power BI performance feature that stores summarized data in the dataset, so the engine can satisfy the visual's query from the smaller aggregation table instead of the 200-million-row fact table. Option A does not help because a table visual still requires the same underlying aggregation and scan of the fact table, and it changes the presentation rather than the performance. Option B is wrong because restricting to top 100 rows changes the report results and does not address the aggregation cost for the full matrix. Option D is wrong because enabling 'Show items with no data' typically increases query workload by forcing the engine to evaluate empty combinations, making performance worse rather than better.

Answer

Change the matrix visual to a table visual

Answer

Use a measure that sums SalesAmount and use the 'Filter' pane to restrict to top 100 rows

Answer

Enable 'Show items with no data' on the matrix

Question 2

You are building a Power BI report for the HR department. You have a table 'Employees' with columns: EmployeeID, Name, Department, HireDate, Salary, and ManagerID. You need to create a hierarchy for organizational chart that allows users to drill from CEO down to individual employees. The hierarchy should be dynamic based on the ManagerID. Which approach should you use? A. Create a parent-child hierarchy using DAX PATH and PATHITEM functions. B. Create a calculated column that concatenates all manager levels. C. Use the built-in drill-down feature with a matrix visual. D. Create separate tables for each level and merge them. Which option is the best?

Accepted Answer

Create a parent-child hierarchy using DAX PATH and PATHITEM functions. The correct option is D: Create a parent-child hierarchy using DAX PATH and PATHITEM functions. In this scenario, the Employees table stores the reporting relationship in ManagerID, which is a self-referencing parent-child structure; DAX PATH can traverse those relationships to produce a delimited path of manager IDs, and PATHITEM can extract each level for dynamic drill-down from CEO to individual employees. This is the standard Power BI pattern for ragged or variable-depth organizational hierarchies. Option A does not fit because separate level tables and merging would be static and would not dynamically reflect ManagerID changes. Option B is insufficient because a matrix drill-down alone does not define the recursive manager-employee hierarchy. Option C is not appropriate because concatenating manager levels into a calculated column does not create a proper drillable hierarchy and is not the PATH/PATHITEM approach.

Answer

Create separate tables for each level and merge them

Answer

Use the built-in drill-down feature with a matrix visual

Answer

Create a calculated column that concatenates all manager levels

Question 3

You have a Power BI dataset that includes a table 'Orders' with columns: OrderDate, CustomerID, ProductID, Quantity, and Revenue. You need to create a measure that calculates the running total of Revenue over the last 12 months, but only for products that have been sold in the current month. The measure should be used in a line chart showing monthly revenue. You have the following options: A. Use the TOTALQTD function with a filter for last 12 months. B. Use CALCULATE with DATESINPERIOD and a filter on products with sales in the current month. C. Create a calculated column for running total and then sum it. D. Use the WINDOW function (Preview). Which option should you choose?

Accepted Answer

Use CALCULATE with DATESINPERIOD and a filter on products with sales in the current month. CALCULATE with DATESINPERIOD is the standard DAX pattern for a rolling 12-month running total, and it lets you apply a filter to restrict the calculation to products that had sales in the current month. DATESINPERIOD returns a contiguous date range ending at the current filter context, which is exactly what a line chart of monthly revenue needs for a rolling window. The other options do not fit: TOTALQTD (option C) aggregates quarter-to-date, not a rolling 12 months, and cannot produce the required window. A calculated column (option D) is evaluated at refresh time and cannot respond dynamically to the chart's month context, and WINDOW (option A) is a preview function not suited to this time-intelligence requirement.

Answer

Use the WINDOW function (Preview)

Answer

Use TOTALQTD with a filter for last 12 months

Answer

Create a calculated column for running total and then sum it

Question 4

You are a Power BI administrator for a large enterprise. You have a shared dataset that is used by multiple reports. The dataset contains sensitive financial data. You need to implement row-level security (RLS) so that managers can only see data for their own region. The dataset has a table 'Sales' with RegionID, and a table 'Managers' with ManagerID, ManagerName, and RegionID. You need to create an RLS role that filters the Sales table based on the logged-in user's region. You have the following options: A. Create a role with a DAX filter: 'Sales[RegionID] = USERPRINCIPALNAME()'. B. Create a role with a DAX filter: 'Sales[RegionID] = LOOKUPVALUE(Managers[RegionID], Managers[ManagerName], USERPRINCIPALNAME())'. C. Create a role with a DAX filter: 'Sales[RegionID] = USERNAME()'. D. Create a role with a static filter for each region. Which option should you choose?

Accepted Answer

Create a role with a DAX filter: 'Sales[RegionID] = LOOKUPVALUE(Managers[RegionID], Managers[ManagerName], USERPRINCIPALNAME())'. The correct choice. It uses LOOKUPVALUE to look up the region for the logged-in user (via USERPRINCIPALNAME) from the Managers table, then applies that filter to the Sales table. Option A directly compares RegionID to USERPRINCIPALNAME, which is a mismatch. Option C uses USERNAME which is less reliable. Option D requires static filters and lacks scalability.

Answer

Create a role with a DAX filter: 'Sales[RegionID] = USERPRINCIPALNAME()'

Answer

Create a role with a DAX filter: 'Sales[RegionID] = USERNAME()'

Answer

Create a role with a static filter for each region

Question 5

You have a Power BI report that uses a date table with a continuous date range. You want to add a slicer that allows users to select a single month and then display data for that month only. You add a slicer visual with the Date field. However, the slicer shows individual dates instead of months. How should you configure the slicer to show months? A. Change the slicer type to 'Between' and then select a month range. B. Create a calculated column for Month and use that in the slicer. C. Use the 'Hierarchy' slicer with Date hierarchy. D. Set the slicer to 'List' and enable 'Show select all'. Which option is best?

Accepted Answer

Create a calculated column for Month and use that in the slicer. The correct option is B: create a calculated column for Month and use that in the slicer. When a slicer is bound directly to a Date field, Power BI exposes the field's native granularity (individual dates), so to let users pick a single month you must supply a field whose values are months, e.g. a DAX calculated column such as Month = FORMAT('Date'[Date], "MMMM") or a month column in the date table, and place that on the slicer. Option A (List with 'Show select all') only adds a select-all control; it does not change the granularity, so the slicer still lists individual dates. Option C (Hierarchy slicer with the Date hierarchy) lets users drill from Year to Quarter to Month but does not present a flat single-month selection as required. Option D ('Between' range) filters a continuous date range and still operates on dates rather than a discrete month selection.

Answer

Set the slicer to 'List' and enable 'Show select all'

Answer

Use the 'Hierarchy' slicer with Date hierarchy

Answer

Change the slicer type to 'Between' and then select a month range

Question 6

You have a Power BI report that displays key performance indicators (KPIs) using a KPI visual. The visual shows a measure 'Current Sales' with a goal of 'Target Sales'. You want to show the status (on track, behind, etc.) based on the difference. You configure the KPI visual with the measure, goal, and trend axis. However, the status indicator does not appear. What should you do? A. Ensure the measure and goal are both numeric and have the same unit. B. Add a trend line to the visual. C. Set the 'Direction' property to 'High is good' or 'Low is good'. D. Use a different visual like a gauge. Which option is the best?

Accepted Answer

Set the 'Direction' property to 'High is good' or 'Low is good'. The KPI visual requires setting the direction to calculate status. Option A is wrong because units don't need to be same. Option B is wrong because trend line is optional. Option D is wrong because gauge is an alternative but not a fix for KPI.

Answer

Add a trend line to the visual

Answer

Ensure the measure and goal are both numeric and have the same unit

Answer

Use a different visual like a gauge

Question 7

You are building a Power BI report to analyze sales performance. You need to allow users to dynamically switch between different measures (e.g., Sales Amount, Sales Quantity, Profit Margin) using a single slicer. Which two features should you implement?

Accepted Answer

Create a disconnected parameter table with measure names.. Option A is correct because a disconnected parameter table containing the measure names (created via 'Enter Data' or DAX) provides the slicer source, and a SWITCH measure referencing SELECTEDVALUE on that table returns the chosen measure dynamically. Option D is correct because field parameters (Modeling > New parameter > Fields) natively generate a table of measure names that can be bound to a slicer, letting users swap the measure shown in a visual without writing custom DAX. Option B is not the right fit here because calculation groups are primarily used to apply reusable calculation modifications (e.g., time intelligence, currency conversion) across many measures, not to let a slicer pick which base measure to display. Option C is wrong because report page tooltips only show contextual information on hover and cannot drive measure selection. Option E is wrong because a calculated table stores static computed rows/values and cannot dynamically respond to a slicer to switch the measure used in a visual.

Answer

Implement a calculation group to switch measures.

Answer

Use a report page tooltip to display measure choices.

Answer

Create a calculated table to hold measure values.

Question 8

You are designing a Power BI report for the executive team. The report must meet the following requirements:
- The report must be accessible to users with visual impairments.
- Visuals must automatically adjust to display the most important data when viewed on mobile devices.
- Users must be able to drill through from a summary page to a detail page by clicking on a data point.
Which three features should you implement?

Accepted Answer

Enable 'Use high contrast colors' in the report theme.. Option A is correct because enabling high contrast colors in the report theme improves accessibility for users with visual impairments by increasing the contrast between text and background elements, making visuals easier to perceive. Option C is correct because a drillthrough page in Power BI allows users to right-click a data point on a summary page and navigate to a detail page filtered to that specific data point, directly satisfying the drill-through requirement. Option D is correct because configuring responsive visuals for the mobile layout lets Power BI automatically rearrange, resize, and prioritize the most important visuals when the report is viewed on mobile devices. Option B is not correct because automatic page refresh addresses real-time data updates, not accessibility, mobile responsiveness, or drillthrough. Option E is not correct because bookmarks can simulate navigation but do not provide true drillthrough filtering based on the selected data point, which is what the scenario requires.

Answer

Enable automatic page refresh for real-time data.

Answer

Use bookmarks to create a drillthrough experience.

Question 9

You are creating a Power BI report to analyze customer feedback. You need to display the distribution of feedback ratings (1-5 stars) and also show the trend of average rating over time. Which two visual types should you use?

Accepted Answer

Column chart. Option B (Column chart) is correct because a column chart is the standard Power BI visual for displaying the distribution of a categorical/discrete measure such as feedback ratings from 1 to 5 stars, letting you see how many responses fall into each rating value. Option E (Line chart) is correct because a line chart is designed to show trends over a continuous axis such as time, making it ideal for plotting the average rating across dates or periods. Option A (Pie chart) is not appropriate because it shows part-to-whole proportions of a single total rather than a distribution across rating values or a trend over time. Option C (Histogram) is not a native Power BI visual type (it is achieved via a column chart or custom visual) and is not the intended answer here. Option D (Scatter chart) is used to show the relationship/correlation between two numeric measures, not a rating distribution or a time-based trend.

Answer

Pie chart

Answer

Histogram

Answer

Scatter chart

Question 10

You run the above DAX query in DAX Studio. The result shows profit margin values for each year, but all values are the same for every year despite sales amounts varying. What is the most likely cause?

Accepted Answer

The measures use row context instead of filter context, causing them to evaluate over the entire table.. The correct answer is D: the measures use row context instead of filter context, causing them to evaluate over the entire table. In DAX, a measure must be evaluated in filter context so that the year column in SUMMARIZECOLUMNS filters the underlying Sales rows; if the calculation relies on row context (for example, iterating the full table without CALCULATE or context transition), it ignores the per-year filter and returns the same aggregate profit margin for every year. That matches the symptom of identical values across years while sales amounts vary. Option A is wrong because a calculated column cannot override the filter context of a measure evaluation. Option B is wrong because a division-by-zero issue would produce blanks or errors, not identical non-blank values for each year. Option C is wrong because SUMMARIZECOLUMNS works with measures that use SUMX; SUMX is a valid iterator and does not inherently conflict with SUMMARIZECOLUMNS.

Answer

The Sales table contains a calculated column that overrides the year filter.

Answer

The DIVIDE function is not handling division by zero correctly.

Answer

The SUMMARIZECOLUMNS function is not compatible with measures that use SUMX.

Question 11

You are designing a Power BI report for a sales team. The team needs to see the top 10 products by sales amount, but also want to see the sales amount for all other products aggregated as 'Others'. What is the best approach to create this visual?

Accepted Answer

Use a Top N filter on the visual to show top 10 and enable the 'Others' option in the filter pane.. The best approach in Power BI is to use a Top N filter on the visual and enable the 'Others' option. This will display the top 10 products individually and aggregate all remaining products into a single 'Others' bucket. This method is dynamic, updates with slicers and filters, and is a built-in feature. A calculated column (option D) is static and does not recalculate based on report interactions, making it unsuitable for an interactive sales report.

Answer

Create a calculated table that holds the top 10 products and join it to the main table.

Answer

Use the RANKX function in a measure and filter the visual to show rank <= 10.

Answer

Create a calculated column that categorizes products as 'Top 10' or 'Others' based on rank, then use that column in the visual.

Question 12

You are a Power BI developer for a healthcare organization. You have a semantic model with a 'PatientVisits' fact table (columns: 'VisitID', 'PatientID', 'Date', 'Department', 'DurationMinutes', 'Cost') and a 'Patients' dimension table (columns: 'PatientID', 'Age', 'Gender', 'City'). You need to create a report page that shows the average cost per visit by department and age group. The age groups are: 0-18, 19-35, 36-50, 51-65, 65+. You want to use a custom visual that displays a matrix with departments as rows and age groups as columns, and the value as average cost. You have created a calculated column for age groups in the Patients table. However, when you place the age group column in the matrix columns, the values are not aggregated correctly; instead, each age group shows the same average cost as the overall average. What is the most likely cause?

Accepted Answer

The relationship between PatientVisits and Patients is many-to-many, causing ambiguous filter propagation.. The correct answer is C: the many-to-many relationship between PatientVisits and Patients causes ambiguous filter propagation, so the age group column cannot correctly filter the Cost measure and every age group returns the overall average. In a proper star schema, Patients (one) should relate to PatientVisits (many) via PatientID with single-direction filtering, allowing the age group column to slice the average cost by department and age band. Option A is wrong because using SUM instead of AVERAGE would change the value type, not make all age groups identical. Option B is wrong because age groups belong in the matrix Columns field well to create the age-band columns. Option D is wrong because a calculated column in Patients is still part of the filter chain as long as the relationship is correctly configured.

Answer

The measure used is SUM of Cost instead of AVERAGE.

Answer

The age group column is not added to the matrix column field well; it should be in rows.

Answer

The age group calculated column is not part of the relationship chain; it is not being used as a filter.

Question 13

You are building a Power BI report for a retail company. The report includes a scatter chart that plots Sales Amount (X-axis) versus Profit Margin (Y-axis) for each product. Users want to quickly identify products that are outliers in terms of high sales but low profit margin. Which feature should you configure to automatically highlight these outliers?

Accepted Answer

Configure the 'Outliers' option in the Analytics pane.. The Analytics pane in Power BI provides an Outliers feature for scatter charts that automatically highlights data points that are statistically different from the rest. This is the intended built-in functionality to identify outliers without manual inspection. The other options either do not exist for scatter charts or do not provide automatic outlier detection.

Answer

Add a 'Ratio line' from the Analytics pane.

Answer

Enable the 'Analytics' pane and add a trend line.

Answer

Use the 'High-density sampling' option in the scatter chart formatting.

Question 14

You are building a Power BI report that contains a page-level filter applied to a slicer. You want to ensure that users can see the filter selections they have made on that page. Which visual should you add to the page?

Accepted Answer

A filter pane that is visible to report consumers.. The filter pane is specifically designed to show active filters at the visual, page, and report levels. By making it visible, report consumers can see exactly which filters are applied, including those set by slicers or cross-filtering. This meets the requirement of showing filter selections without building custom measures or additional visuals.

Answer

A card visual that displays the selected values using a measure.

Answer

A table visual that lists all values from the filtered field.

Answer

A slicer visual set to display the same field as the page filter.

Question 15

You are creating a Power BI report that includes a matrix visual showing sales by country and product category. Users need to be able to drill down from country to city, and then to store. They also want to see the data at all levels simultaneously. Which configuration should you apply?

Accepted Answer

Add Country, City, and Store to the Rows well and set 'Stepped layout' to off, then use the 'Expand all' feature.. To show all hierarchy levels simultaneously in a matrix visual, you need to turn off stepped layout and then expand all levels. Stepped layout indents levels, which can make it harder to see all data at once. The 'Expand all' feature, available after turning off stepped layout, displays all levels in a flat table-like format. This is the correct approach.

Answer

Add Country, City, and Store to the Rows well and enable 'Stepped layout'.

Answer

Add Country, City, and Store to the Rows well and enable 'Expand all' by default in the field well.

Answer

Add Country, City, and Store to the Rows well and enable 'Show all levels' in the formatting options.