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

Question 1

Your Power BI report includes a map visual showing store locations. However, some locations are not appearing correctly because of ambiguous place names. What should you do to ensure accurate geocoding?

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

Accepted Answer

Use latitude and longitude fields instead of location names. Using latitude and longitude fields bypasses Bing's geocoding, ensuring accuracy. Changing the map style does not fix geocoding, using a filled map is for regions, and a bubble chart is not geographic.

Answer

Aggregate the data by country

Answer

Switch to a bubble chart

Answer

Change the map visual to a filled map

Question 2

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 3

Which TWO actions are best practices for designing accessible Power BI reports? (Choose two.)

Accepted Answer

Provide descriptive alt text for all visuals. Descriptive alt text helps screen reader users understand the content of visuals. Option E is correct because clear titles provide context and improve navigation for all users, including those using assistive technologies. Option A is incorrect because complex tab orders can confuse keyboard users; a logical reading order is better. Option C is incorrect because while high contrast can help some users, it is not always necessary and may reduce readability for others. Option D is incorrect because decorative images should be marked as decorative, not given alt text, to avoid clutter for screen reader users.

Answer

Use complex tab order to navigate quickly

Answer

Use only high-contrast colors

Answer

Add alt text to every image, including decorative ones

Question 4

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

Accepted Answer

Calculated columns. Calculated columns allow creating custom text fields by combining or transforming data using DAX, which can be used in visuals as narratives. DAX measures can return dynamic text values (e.g., via CONCATENATE or FORMAT) that update with filters, serving as custom narratives. Custom visuals from AppSource can include text-based visualizations for storytelling. Smart Narratives is an automated feature, not customizable. Bookmarks store report state but do not contain narrative text.

Answer

Smart Narratives visual

Answer

Bookmarks

Question 5

Which TWO visuals are most suitable for showing the distribution of a single numeric variable? (Choose two.)

Accepted Answer

Box and whisker plot. Box and whisker plots (C) and histograms (D) are both effective for visualizing the distribution of a single numeric variable. A box and whisker plot displays the median, quartiles, and outliers, providing a summary of the distribution. A histogram shows the frequency distribution by binning the data. Option A (pie chart) is for parts of a whole; option B (scatter chart) is for correlation between two variables; and option E (bar chart) is for comparing categories, not distribution.

Answer

Pie chart

Answer

Scatter chart

Answer

Bar chart

Question 6

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 7

You need to allow users to ask questions about their data using natural language. Which Power BI feature should you enable?

Accepted Answer

Q&A visual. The Q&A visual in Power BI allows users to ask questions about their data using natural language, automatically generating visualizations based on the query. This feature is specifically designed for natural language querying, making it the correct choice for enabling users to interact with data conversationally.

Answer

Key Influencers visual

Answer

Quick Insights

Answer

Copilot

Question 8

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 9

A Power BI report shows a line chart of monthly sales. The user wants to add a horizontal line representing the target sales of $100,000. Which approach should you recommend?

Accepted Answer

Use the analytics pane to add a constant line. The analytics pane in Power BI allows you to add a constant line to a line chart to represent a target value. Option A is incorrect because the constant line feature is located in the analytics pane, not the formatting pane. Option B is incorrect because a gauge visual is not designed to show a trend line over time. Option C is incorrect because a calculated column would not display as a horizontal line; it would add data points.

Answer

Add a constant line from the formatting pane

Answer

Add a gauge visual to display the target

Answer

Create a calculated column with the target value

Question 10

You are designing a Power BI report for executives. The dataset contains sales data with a many-to-many relationship between 'Sales' and 'Product' tables via a 'ProductSales' bridge table. Users complain that some measures return incorrect totals when using multiple related fields. What is the most likely cause?

Accepted Answer

The many-to-many relationship is causing ambiguity in measure evaluation. Many-to-many relationships in Power BI can cause ambiguity in measure evaluation when multiple related fields are used, leading to incorrect totals. This ambiguity arises because Power BI must determine how to propagate filters across the bridge table, and the default behavior may not match the expected logic. Option B is incorrect because data type mismatches would typically cause errors or blank values, not incorrect totals in measures. Option C is incorrect because cross-filter direction affects how filters flow between tables, but the issue described is specifically about ambiguity in many-to-many relationships, not filter direction. Option D is incorrect because Row-Level Security (RLS) filters data based on user identity, which would consistently apply to all measures and not cause intermittent incorrect totals in the context of many-to-many relationships.

Answer

Data type mismatches between key columns

Answer

The cross-filter direction is set to single instead of both

Answer

Row-level security (RLS) is filtering out some rows

Question 11

You need to create a visual that shows the contribution of each product category to total sales over time. Which visual type is most appropriate?

Accepted Answer

Stacked area chart. A stacked area chart is the most appropriate visual because it displays the cumulative contribution of each category over time, showing how each product category's sales contribute to the total sales across a time period. Option A (Waterfall chart) is incorrect because it is used to show incremental changes or contributions to a total, such as profit or loss over a sequence, not proportions over time. Option C (Pie chart) is incorrect because it shows parts of a whole at a single point in time, not over time. Option D (Scatter plot) is incorrect because it shows relationships between two numerical variables, not composition over time.

Answer

Waterfall chart

Answer

Pie chart

Answer

Scatter plot

Question 12

Refer to the exhibit. The DAX measure is intended to return the previous purchase amount for the same customer. However, it returns the current row's amount for most rows. What is the most likely reason?

Accepted Answer

The variable PreviousDate is evaluated within the current filter context, which may be the same as LastDate for single rows. The variable PreviousDate is evaluated in the current filter context. For a single row per customer per date, the filter context is limited to that row, so PreviousDate equals LastDate, causing the measure to return the current row's amount. Option A is incorrect because the data type of OrderDate is not the issue; even if text, the comparison would still be attempted. Option B is incorrect because ALLEXCEPT correctly retains only CustomerID filter, but the problem arises from how PreviousDate is evaluated. Option D is incorrect because CALCULATE does support that syntax; the issue is the filter context.

Answer

The data type of OrderDate is text, causing comparison issues

Answer

ALLEXCEPT removes all filters except CustomerID, so the measure cannot find the previous date

Answer

The CALCULATE function does not support the 'Sales'[OrderDate] = PreviousDate syntax

Question 13

You have a Power BI report with a matrix visual showing sales by year and quarter. Users want to drill down from year to quarter and expand back up. Which feature should you enable?

Accepted Answer

Enable drill-down mode and add a hierarchy of Year and Quarter. Enable drill-down mode and add a hierarchy of Year and Quarter. Drill-down mode on a matrix visual allows users to expand and collapse hierarchical levels interactively. Adding a hierarchy of Year and Quarter enables navigating from higher to lower levels. Option A is incorrect because drill-through pages navigate to a separate page to show more details, not drill down within the same visual. Option B is incorrect because bookmarks capture static states and do not provide interactive drill-down behavior. Option D is incorrect because tooltip pages show additional details on hover but do not support hierarchical navigation.

Answer

Set up drill-through pages for each quarter

Answer

Create bookmarks for each level

Answer

Add a tooltip page showing quarterly details

Question 14

You need to create a measure that calculates the year-over-year growth percentage for sales. Which DAX function combination is most appropriate?

Accepted Answer

CALCULATE with SAMEPERIODLASTYEAR and DIVIDE. CALCULATE with SAMEPERIODLASTYEAR returns the same period in the previous year, allowing comparison of current and prior year sales. DIVIDE safely computes the year-over-year growth percentage by dividing the difference by the prior year's sales. Options A and D are incorrect because DATEADD and PREVIOUSMONTH do not target year-over-year comparisons. Option C is incorrect because TOTALYTD calculates year-to-date totals, not a full period comparison.

Answer

CALCULATE with DATEADD and SUM

Answer

TOTALYTD and DIVIDE

Answer

PREVIOUSMONTH and SUM

Question 15

You are troubleshooting a Power BI DirectQuery model that connects to a SQL Server database. A slicer on 'Region' is slow to respond. The region column has 50 distinct values. What is the best optimization?

Accepted Answer

Create an index on the Region column in the source database. Creating an index on the Region column in the source database. In DirectQuery mode, every query is sent to the source SQL Server database, so optimizing the source query performance is key. An index on the Region column accelerates the filtering operation for the slicer, which has only 50 distinct values—a low-cardinality column that benefits from a non-clustered index. Option B is incorrect because cache size in Power BI Desktop affects only local caching for imported data, not DirectQuery queries. Option C is incorrect because switching to Import mode changes the data storage and may not be feasible due to data size or real-time requirements. Option D is incorrect because reducing distinct values loses information and is not a proper optimization technique.

Answer

Increase the cache size in Power BI Desktop

Answer

Switch the model to Import mode

Answer

Reduce the number of distinct values in Region