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

Question 1

A Power BI report shows a bar chart with sales by region. When users click on a region, they expect a line chart on the same page to filter to that region's sales over time. However, the line chart does not respond to the click. What is the most likely cause?

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

Accepted Answer

The interaction between the bar chart and line chart is set to 'None'.. In Power BI, visual interactions control how one visual affects another when clicked. By default, cross-filtering and cross-highlighting are enabled, but if the interaction between the bar chart and line chart is explicitly set to 'None', clicking a region on the bar chart will not filter or highlight the line chart. This is the most common cause when a visual fails to respond to clicks on another visual.

Answer

The line chart uses a continuous axis that cannot be filtered.

Answer

The bar chart is not set as a slicer.

Answer

The line chart has a legend with too many items.

Question 2

A company has a dataset with a table 'Orders' containing columns: OrderDate, CustomerID, Amount. They want to create a visual that shows the total amount per month. Which of the following is the best approach?

Accepted Answer

Create a line chart with OrderDate on the axis and use the date hierarchy to drill down to month.. It leverages Power BI's built-in date hierarchy, which automatically groups OrderDate by year, quarter, month, and day. By placing OrderDate on the axis of a line chart and drilling down to the month level, you get an accurate monthly aggregation of Amount without needing any manual data transformation or calculated columns. This approach is efficient, maintains the underlying data model's integrity, and allows for easy drill-up/drill-down navigation.

Answer

Create a pie chart with OrderDate as the legend.

Answer

Create a table visual with OrderDate and Amount, then group by month in the visual.

Answer

Create a bar chart with a calculated column 'Month' extracted from OrderDate and use that as the axis.

Question 3

Drag and drop the steps to configure a scheduled refresh for a dataset in the Power BI service into the correct order.

Accepted Answer

Navigate to the dataset in the Power BI service and open its settings, then expand the 'Scheduled refresh' section, then set the refresh frequency and time windows, then click 'Apply' to save.. Scheduled refresh is configured in the dataset settings, enabling automatic updates at specified intervals.

Answer

Set the refresh frequency and time windows, then expand the 'Scheduled refresh' section, then navigate to the dataset in the Power BI service and open its settings, then click 'Apply'.

Answer

Navigate to the dataset in the Power BI service and open its settings, then expand the 'Scheduled refresh' section, then click 'Apply', then set the refresh frequency and time windows.

Answer

Expand the 'Scheduled refresh' section, then navigate to the dataset in the Power BI service and open its settings, then set the refresh frequency and time windows, then click 'Apply'.

Question 4

Which TWO actions can you perform using Power BI Desktop's Query Editor? (Choose two.)

Accepted Answer

Merge two tables based on a common column.. In Power BI Desktop's Query Editor, you can merge two tables based on a common column using the 'Merge Queries' feature (option B) and remove duplicate rows using the 'Remove Duplicates' feature (option D). Creating a relationship between tables (option C) is not performed in Query Editor; it is done in the Model view after loading data. Defining row-level security roles (option A) and creating DAX measures (option E) are also not available in Query Editor — roles are managed in the Modeling tab or Power BI Service, and measures are created in the Report or Data view.

Answer

Define row-level security (RLS) roles.

Answer

Create a relationship between two tables.

Answer

Create a new measure using DAX.

Question 5

Which THREE of the following are valid methods to enhance the accessibility of a Power BI report? (Choose three.)

Accepted Answer

Provide keyboard navigation support by setting tab order.. Setting tab order in Power BI allows keyboard-only users to navigate through report visuals in a logical sequence, which is a core requirement of WCAG 2.1 success criterion 2.4.3 (Focus Order). Option C is correct because Power BI provides built-in high contrast themes that enhance readability for users with visual impairments. Option E is correct because adding alt text to visuals ensures screen readers can convey the content to visually impaired users. Option D is not considered a valid method for this question; while using a color-blind friendly palette is a good design practice, it is not specifically a method to enhance accessibility in the context of the exam. Option A is incorrect as animations can distract and are not an accessibility feature.

Answer

Add animations to visuals to draw attention.

Answer

Use a color-blind friendly palette.

Question 6

You have a Power BI report with a matrix visual showing sales by region and product category. You want to allow users to expand and collapse groups. Which feature should you enable?

Accepted Answer

Drill-down mode. Drill-down mode in a matrix visual allows users to expand and collapse hierarchical levels. When a hierarchy is present, enabling drill-down mode provides expand/collapse icons on row headers, letting users interactively show or hide subcategories. Option A (page tooltips) shows tooltip pages on hover, unrelated to expand/collapse. Option C (drill-through) navigates to another report page, not within the same visual. Option D (row and column subtotals) is a formatting feature for aggregating totals, not for expanding/collapsing groups.

Answer

Page tooltips

Answer

Drill-through

Answer

Row and column subtotals

Question 7

You are building a Power BI report that uses a live connection to an Azure Analysis Services (AAS) tabular model. Users need to be able to filter data using a slicer that shows only products that have been sold in the current year. What should you do?

Accepted Answer

Create a calculated table in the AAS model that returns only products sold in the current year. A calculated table in the AAS model can be created using DAX to dynamically return only products sold in the current year (e.g., using FILTER, CALCULATETABLE, YEAR, and TODAY functions). This table is available in Power BI via live connection and can be used as the slicer source. Option A is wrong: a calculated column in the Product table is static at process time and does not dynamically filter to current year; it also adds a column to the entire table, not a subset. Option B is wrong: a visual-level filter on the slicer relies on the underlying data model; with live connection, you cannot create new tables in Power BI Desktop, and filtering on a date condition would require the slicer to use a field from a different table, which is not straightforward or recommended. Option D is wrong because live connections to AAS do not allow creating calculated tables in Power BI Desktop; all data modeling must be done in the source model.

Answer

Add a calculated column to the Product table in the AAS model that marks products sold this year

Answer

Use a filter on the slicer visual to show only products where sales year equals current year

Answer

Create a calculated table in Power BI Desktop using DAX to filter products

Question 8

You have a Power BI report that uses a custom visual from AppSource. The visual is not rendering correctly. Which three steps should you take to troubleshoot?

Accepted Answer

Check if the visual version is compatible with your Power BI Desktop version. Options B, C, and E are correct. Checking compatibility (B) ensures the visual supports your version of Power BI Desktop. Updating the visual (C) can fix known bugs. Verifying correct data fields (E) ensures the visual has the necessary input. Option A, disabling hardware acceleration, is a general troubleshooting step not specific to custom visuals. Option D, clearing browser cache, applies to Power BI Service, not Desktop.

Answer

Disable hardware acceleration in Power BI Desktop

Answer

Clear the browser cache

Question 9

Refer to the exhibit. You have a DAX measure that calculates customer lifetime value (CLV) as total revenue divided by distinct customer count. When you use this measure in a visual with Product category, you notice that the CLV values are higher than expected. What is the most likely reason?

Accepted Answer

The measure counts customers per category, but customers who buy multiple categories are counted in each category, reducing the denominator. The CLV measure is defined as total revenue divided by distinct customer count. When this measure is used in a visual with Product category, the context filters both the revenue and the customer count to that category. The DISTINCTCOUNT(CustomerID) returns the number of customers who purchased at least one product in that category. If a customer buys multiple categories, they are counted in each category's distinct count. This makes the denominator per category smaller than the total distinct customer base, leading to a higher CLV value than expected. Option A is incorrect because returns would reduce revenue, not cause higher CLV. Option C is incorrect because using COUNTROWS would count transaction rows, not distinct customers, making the denominator larger and CLV smaller. Option D is incorrect because DIVIDE handles division by zero, and the scenario does not involve zero customers.

Answer

The measure does not filter out returns

Answer

The measure should use COUNTROWS instead of DISTINCTCOUNT

Answer

The measure is dividing by zero for categories with no customers

Question 10

Which TWO of the following are valid methods to share a Power BI report with external users who do not have an internal Microsoft Entra ID account? (Select two.)

Accepted Answer

Deploy the report to Power BI Report Server and configure anonymous access. Deploy the report to Power BI Report Server and configure anonymous access allows external users without Microsoft Entra ID accounts to view the report via a web portal or URL. Option C is correct: Inviting them as guest users in Microsoft Entra ID (B2B) enables external users to access the report through the Power BI service using their existing email address. Option A is wrong: Publishing to public web makes the report publicly accessible to anyone on the internet, not just specific external users. Option D is wrong: Email subscriptions send a static snapshot of the report, not an interactive experience. Option E is wrong: Embedding in SharePoint Online requires the user to have a valid Power BI license and access to the report via the Power BI service, which typically requires internal authentication.

Answer

Publish to public web (Publish to web)

Answer

Send them an email subscription with the report attached

Answer

Embed the report in a SharePoint Online page and share the link

Question 11

You have a Power BI report that uses a custom visual from AppSource. The visual is not rendering correctly. What should you check first?

Accepted Answer

The visual is not certified by Microsoft.. Custom visuals are embedded in the report file when published from Power BI Desktop; they do not require a network connection to AppSource to render. If a visual is not rendering, first check whether the visual is certified by Microsoft, as the Power BI service administrator might have disabled the use of uncertified visuals. Option A is incorrect because the visual does not rely on a live connection to AppSource. Option B is incorrect because report themes only affect styling, not rendering. Option C is incorrect because RLS filters data but does not prevent visual rendering.

Answer

The network connection is blocked from reaching AppSource.

Answer

The visual is not compatible with the report theme.

Answer

The dataset has row-level security applied.

Question 12

You have a Power BI dataset with a large fact table. You need to optimize report performance when users filter by date. What should you do?

Accepted Answer

Mark the date table as a date table in Power BI.. Marking a date table as a date table enables time intelligence functions and better performance. Option B is wrong because hiding columns does not improve performance. Option C is wrong because disabling cross-filtering might affect user experience but not performance directly. Option D is wrong because summarizing the fact table reduces granularity, which may not be desired.

Answer

Hide all columns except the date column.

Answer

Disable cross-filtering between tables.

Answer

Summarize the fact table by month.

Question 13

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

Accepted Answer

The ALL('Date') function removes the filter context, so the calculation returns total sales for all dates.. Using ALL('Date') within CALCULATE removes the filter context on the Date table, causing the measure to return the total sales across all dates, not the current date context. Option A is incorrect; ALLEXCEPT would keep certain filters, but the problem here is specifically the removal of all date filters by ALL. Option C is incorrect; using MIN versus MAX in VAR SelectedDate does not cause the described behavior; the issue is the ALL function. Option D is incorrect; an inactive relationship would prevent proper filtering but would not result in the measure returning the total for all dates; the symptom would be different.

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 14

You have a Power BI report that shows sales by region. Users report that the map visual is not displaying data for some countries. What is the most likely cause?

Accepted Answer

The geographic data is not categorized correctly in the Data pane.. The most likely cause is that the geographic data is not categorized correctly in the Data pane. Power BI map visuals rely on the data category (e.g., Country, State, City) assigned to each field to correctly geocode and plot locations. If a field containing country names is left as 'Text' or 'Uncategorized', Power BI may fail to recognize the values as geographic entities, resulting in missing data points on the map.

Answer

The report page filter is excluding those countries.

Answer

The map visual is limited to 30 data points.

Answer

The map visual only supports US addresses.

Question 15

You have a report with a line chart showing monthly sales. Users need to see the exact sales value when they hover over a data point. What should you configure?

Accepted Answer

Configure the visual's tooltip to display the value.. Tooltips in Power BI are designed to show detailed information about a data point when the user hovers over it. By default, the visual's tooltip already includes the value, but if it has been customized or removed, you need to ensure the tooltip is configured to display the sales value. This provides an interactive way to see exact numbers without cluttering the chart with permanent labels.

Answer

Enable data labels on the chart.

Answer

Add a report page tooltip.

Answer

Set the category label to show the value.