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

Question 1

You have a Power BI report that includes a line chart showing monthly sales. You want to add a trend line to help users identify the overall direction of sales over time. Which feature should you use?

Accepted Answer

Analytics pane in the visual. The correct option is D, the Analytics pane in the visual. The Analytics pane in Power BI line charts provides the 'Trend line' option, which adds a linear trend line to help identify the overall direction of sales over time. Option A is wrong because the Forecast option is used for predicting future values, not for adding a trend line. Option B is wrong because while you can create a DAX measure to calculate a linear regression line, it is not the built-in feature designed for this purpose. Option C is wrong because the format pane only changes visual appearance (e.g., line style, colors), not analytical elements like trend lines.

Answer

Forecast option in the visual

Answer

Add a DAX measure for linear regression

Answer

Format pane to change line style

Question 2

You are building a Power BI report from a large dataset (10 GB) stored in Azure Synapse Analytics. The dataset includes a fact table with 500 million rows. You need to minimize the amount of data imported into Power BI while still allowing users to filter by year and product category. Which approach should you use?

Accepted Answer

Configure Incremental Refresh with a filter on year. Incremental Refresh allows you to filter data during import (e.g., only recent years) and then further filter by product category, minimizing the data imported. Option A is wrong because DirectQuery does not import data but can be slow on large tables and puts load on the source. Option B is wrong because importing only necessary columns reduces the width but not the number of rows (500 million rows still imported). Option C is wrong because creating an aggregation table reduces granularity and may not allow detailed filtering by both year and product category if the aggregation is at a higher level; additionally, it requires extra storage and processing.

Answer

Use DirectQuery to avoid importing data

Answer

Import only the necessary columns from the fact table

Answer

Create an aggregation table on year and product category

Question 3

You are designing a Power BI dashboard for executive review. The dashboard must include a card visual showing the total sales for the current year. You need to ensure that the card visual updates automatically when data refreshes. Which TWO actions should you take?

Accepted Answer

Configure a scheduled refresh for the dataset. To ensure a card visual showing total sales for the current year updates automatically when data refreshes, you need to configure a scheduled refresh (A) so the dataset is refreshed on a recurring basis, and enable page auto-refresh (D) so the visuals on the report page re-render to reflect the latest data. Option B is incorrect because Power BI does not support per-visual refresh intervals; auto-refresh is set at the page level. Option C is incorrect because a measure that recalculates on interaction does not cause automatic updates; it only recalculates when a user interacts, not on data refresh. Option E is incorrect because refresh on page load is not a built-in setting; the page auto-refresh feature handles periodic updates.

Answer

Set the visual to refresh every 5 minutes

Answer

Use a measure that recalculates on every interaction

Answer

Set the report to refresh on page load

Question 4

You have a Power BI report that uses a composite model with a DirectQuery source and an imported table. Users report that some visuals show incorrect totals when using measures that reference both sources. Which THREE conditions must be met to ensure correct results?

Accepted Answer

Ensure relationships are defined with appropriate cardinality and cross-filter direction. Options A, C, and E are correct. In a composite model with both DirectQuery and imported tables, defining relationships with appropriate cardinality and cross-filter direction (A) is essential to ensure correct query behavior. Using measures that aggregate data at the appropriate granularity (C) ensures that calculations consider the correct filter context across storage modes. Setting 'Assume Referential Integrity' (E) on relationships between the sources allows Power BI to optimize queries by assuming referential integrity, which improves performance without affecting correctness. Option B (setting both sources to Dual storage mode) is not required and may not be applicable. Option D (enabling 'Reduce queries') is a report setting for performance but does not fix incorrect totals.

Answer

Set both sources to Dual storage mode

Answer

Enable 'Reduce queries' in report settings

Question 5

You are reviewing a DAX query that returns total sales by year and quarter. However, the result includes rows for quarters with no sales. Which modification should you make to exclude empty rows?

Accepted Answer

Add a filter: 'FILTER(ALL('Date'), NOT ISBLANK([Total Sales]))' inside SUMMARIZECOLUMNS. SUMMARIZECOLUMNS returns rows for all combinations of grouping columns, even if the measure returns BLANK. To exclude rows where the measure is blank, you can apply a filter like FILTER(ALL('Date'), NOT ISBLANK([Total Sales])) to remove those rows. Option B is incorrect because SUMMARIZECOLUMNS does not automatically exclude blank rows; it returns blank rows by default. Option C is incorrect because using ADDCOLUMNS with SUMMARIZE would not inherently exclude blank rows. Option D is incorrect because NATURALINNERJOIN would only keep matching rows, but it would not filter based on the measure value.

Answer

No modification is needed; SUMMARIZECOLUMNS already excludes blank rows

Answer

Replace SUMMARIZECOLUMNS with ADDCOLUMNS(SUMMARIZE(...))

Answer

Wrap the SUMMARIZECOLUMNS in a NATURALINNERJOIN with Sales table

Question 6

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?

Accepted Answer

Create an aggregation table on Store and ProductCategory with pre-calculated SalesAmount. Creating an aggregation table at a higher granularity (Store, ProductCategory) allows Power BI to use aggregated data for the visual, drastically reducing query time while preserving granularity. Option A is wrong because a table visual does not improve performance; it still queries the full fact table. Option B is wrong because restricting to top 100 rows does not improve the underlying query; the measure still sums over the entire table. Option D is wrong because enabling 'Show items with no data' increases the number of rows and can worsen performance.

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 7

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. Power BI supports parent-child hierarchies using DAX functions like PATH and PATHITEM to create a hierarchy from a self-referencing table (Employees table with ManagerID). This allows dynamic drill-down from CEO to individual employees. Option A is wrong because creating separate tables for each level is complex and not dynamic. Option B is wrong because the built-in drill-down feature in a matrix visual requires explicit hierarchy levels, not a dynamic parent-child structure. Option C is wrong because concatenating manager levels does not create a usable hierarchy for drill-down.

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 8

You have a Power BI report that displays sales data by region. The report includes a map visual showing sales amount by state. You notice that some states are not displayed on the map because the state names in the data do not match the standard names used by Power BI's map visualization. For example, 'California' is correct but 'CA' is not recognized. You need to ensure all states appear correctly. Which action should you take? A. Create a calculated column that maps state abbreviations to full names using a SWITCH statement. B. Change the map visual to a filled map. C. Use the 'Data category' property to set the field to 'State or Province'. D. Add a custom map image. Which option is the best?

Accepted Answer

Create a calculated column that maps state abbreviations to full names using a SWITCH statement. Creating a calculated column using a SWITCH statement or a mapping table can convert state abbreviations to full names, ensuring the map visualization recognizes all states. Option A is incorrect because setting the data category to 'State or Province' only tells Power BI how to interpret the existing data; it does not change the values, so 'CA' would still not be recognized. Option C is incorrect because adding a custom map image requires additional setup and may not resolve the recognition issue. Option D is incorrect because a filled map has the same value recognition issues as a regular map.

Answer

Use the 'Data category' property to set the field to 'State or Province'

Answer

Add a custom map image

Answer

Change the map visual to a filled map

Question 9

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. You can use CALCULATE with DATESINPERIOD to compute the running total over 12 months, and add a filter to restrict to products that have sales in the current month. Option A is wrong because the WINDOW function is still in preview and not recommended for production. Option C is wrong because TOTALQTD is for quarter-to-date, not rolling 12 months. Option D is wrong because calculated columns are static and not dynamic for each month.

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 10

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 11

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. Creating a Month column (e.g., 'Month Year') allows users to select a single month. Option A is wrong because setting the slicer to 'List' with 'Show select all' still shows individual dates, not months. Option C is wrong because a hierarchy slicer shows drill-down behavior, not a single month selection at the top level. Option D is wrong because the 'Between' slicer type still displays date ranges, not months.

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 12

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 13

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.. The correct combination is using a disconnected parameter table (A) and field parameters (D). A disconnected parameter table can store measure names and be used in a slicer; then, field parameters allow the measure to dynamically change the value displayed in visuals by binding the slicer selection to a measure via SELECTEDVALUE or similar DAX. Field parameters are specifically designed for dynamic field/measure selection. Option B (calculation group) is a valid alternative but is not one of the two requested features, and options C (report page tooltip) and E (calculated table) do not provide dynamic measure switching in this context.

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 14

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.. To meet the requirements:
- A (Enable 'Use high contrast colors' in the report theme) improves accessibility for visually impaired users by increasing color contrast.
- C (Create a drillthrough page with relevant fields) allows users to click a data point on a summary page and navigate to a detail page filtered by that data point.
- D (Configure responsive visuals for mobile layout) ensures visuals automatically adjust to display the most important data on mobile devices.

Option B (automatic page refresh) is unrelated to accessibility, mobile responsiveness, or drillthrough; it is for real-time data scenarios. Option E (using bookmarks) creates a navigation experience but does not provide the context-filtered drillthrough behavior required.

Answer

Enable automatic page refresh for real-time data.

Answer

Use bookmarks to create a drillthrough experience.

Question 15

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. To show the distribution of feedback ratings (1-5 stars), a column chart is appropriate because it displays the count or frequency of each rating category. For the trend of average rating over time, a line chart is suitable as it shows changes over a continuous period. Therefore, the correct answers are B (Column chart) and E (Line chart). Other options: A (Pie chart) shows proportions but not distribution, C (Histogram) is not a standard Power BI visual, and D (Scatter chart) is used for relationships between variables.

Answer

Pie chart

Answer

Histogram

Answer

Scatter chart