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

Question 1

You have a Power BI report that uses a DirectQuery connection to a SQL Server database. You need to improve the performance of a visual that shows a large number of data points. What is the best action to take?

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

Accepted Answer

Add a slicer to limit the data range.. Adding a slicer filters the data, reducing the amount of data queried from the SQL Server via DirectQuery, thus improving performance. Option A is incorrect because increasing the number of data points increases the query load and worsens performance. Option C is incorrect because changing to Import mode would load all data into memory, which may improve query speed but can be impractical for large datasets and requires a full data refresh. Option D is incorrect because disabling cross-filtering between visuals does not reduce the data volume queried; it only affects interactions.

Answer

Increase the number of data points displayed in the visual.

Answer

Change the storage mode to Import.

Answer

Disable the 'cross-filter' interaction between visuals.

Question 2

You are creating a Power BI report to visualize customer feedback scores. The data contains a column 'FeedbackDate' with dates and a column 'Score' with values from 1 to 10. You want to show a trend line of average score over time. Which visual type is most appropriate?

Accepted Answer

Line chart. A line chart is ideal for showing trends over time. Option A is wrong because a pie chart shows proportions, not trends. Option B is wrong because a card shows a single aggregate value, not a trend. Option C is wrong because a table displays raw data, not a trend.

Answer

Pie chart

Answer

Card

Answer

Table

Question 3

You have a Power BI dataset with a 'Sales' table that includes a 'ProductID' column. You also have a 'Products' table with 'ProductID' and 'Category' columns. You create a relationship between the tables. You want to create a measure that calculates the total sales for products in the 'Electronics' category. Which DAX expression should you use?

Accepted Answer

CALCULATE(SUM(Sales[Amount]), Products[Category] = "Electronics"). The CALCULATE function modifies the filter context to include only rows where Products[Category] equals 'Electronics'. The relationship between Sales and Products ensures that filtering Products also filters Sales appropriately. Option A is invalid syntax; SUMX requires an expression, not multiple arguments like that. Option B is incorrect because RELATED is a row-context function used in calculated columns, not as a filter argument in CALCULATE. Option C sums all sales without any filter.

Answer

SUMX(Products, Products[Category] = "Electronics", Sales[Amount])

Answer

CALCULATE(SUM(Sales[Amount]), RELATED(Products[Category]) = "Electronics")

Answer

SUM(Sales[Amount])

Question 4

You need to create a Power BI report that uses data from Microsoft Excel files stored in SharePoint Online. The data should refresh automatically every hour. What is the recommended approach?

Accepted Answer

Use the SharePoint Online folder connector in Power Query and set up a scheduled refresh in the Power BI service.. The SharePoint Online folder connector in Power Query connects to a folder of Excel files, and you can set up a scheduled refresh in the Power BI service to refresh data from those files every hour. Option B is incorrect because the Excel Online connector connects to a single Excel file, not a folder, so it cannot handle multiple files; it does support scheduled refresh for files in SharePoint Online, but it is not the recommended approach for multiple files. Option C is incorrect because manually uploading files does not enable automated scheduled refresh. Option D is incorrect because importing Excel files into Power Query is a transformation step, not a data source connector; you still need a data source that supports refresh, such as the SharePoint folder connector.

Answer

Use the Excel Online connector in Power BI Desktop.

Answer

Manually upload the Excel files to the Power BI service each time.

Answer

Import the Excel files into Power Query and then publish.

Question 5

You have a Power BI report that uses a bar chart to show sales by region. Users report that the chart is difficult to read because many regions have similar sales values. You need to improve the readability without changing the data. Which visual should you use?

Accepted Answer

Small multiples (bar chart). A small multiples chart splits the bar chart into multiple smaller panels, each showing a subset of the data (e.g., one region per panel), making it easier to compare similar values across regions. Option A (Line chart) is incorrect because line charts are best for trends over time, not for comparing categorical values. Option B (Treemap) is incorrect because treemaps show hierarchical proportions, not suited for comparing similar-sized values. Option C (Donut chart) is incorrect because donut charts show parts of a whole, not multiple categories with similar values.

Answer

Line chart

Answer

Treemap

Answer

Donut chart

Question 6

You are designing a Power BI report for executives. They need to quickly see the top 10 products by revenue and the trend of revenue over the last 12 months. Which combination of visuals should you include on a single page?

Accepted Answer

Stacked bar chart for top products and a line chart for monthly revenue trend. A stacked bar chart effectively visualizes the top 10 products by revenue, and a line chart is ideal for showing the revenue trend over time. Option B is incorrect because a clustered bar chart for top products can be used, but a stacked bar chart for monthly revenue would not clearly show the trend; a line chart is preferred. Option C is incorrect because a funnel chart is designed for showing stages in a process, not for ranking top products by revenue. Option D is incorrect because a table is not as visually impactful as a chart for quick insights, and a pie chart is poor for showing trends over time.

Answer

Clustered bar chart for top products and a stacked bar chart for monthly revenue

Answer

Funnel chart for top products and a line chart for monthly revenue

Answer

Table of products and a pie chart for monthly revenue

Question 7

Refer to the exhibit. You have a DAX measure that calculates year-over-year sales growth. When you add this measure to a table visual with Year and Month, some rows show blank values. What is the most likely cause?

Accepted Answer

The Calendar table does not have a continuous date range, causing SAMEPERIODLASTYEAR to return blank for some months. SAMEPERIODLASTYEAR requires a contiguous date range in the Calendar table; if dates are missing, it returns blank for those periods. Option A is wrong because SAMEPERIODLASTYEAR works at month level. Option B is wrong because DIVIDE handles division by zero by returning blank or an alternate value, which is not the issue. Option C is wrong because the measure uses SUM, which does not require an active relationship if the filter context is appropriate.

Answer

The measure cannot be used at the month level because SAMEPERIODLASTYEAR only works at year level

Answer

The measure is trying to divide by zero for months with no sales in the previous year

Answer

The relationship between Sales and Calendar is inactive

Question 8

Refer to the exhibit. You have a JSON definition of a Power BI dataset. You need to ensure that when a user filters by Product[Category], the filters propagate to Sales table. What is the current cross-filtering behavior?

Accepted Answer

Filter from Product flows to Sales. 'oneDirection' means filter flows from the 'one' side (Product) to the 'many' side (Sales). Option B is wrong because 'bothDirections' is not set. Option C is wrong because the filter does propagate. Option D is wrong because the behavior is defined.

Answer

Filter from Sales flows to Product

Answer

No filter propagation occurs

Answer

Filter propagation is bidirectional

Question 9

You have a Power BI report that uses a map visual to show store locations. Some stores have the same latitude and longitude. You want to distinguish overlapping points. Which visual feature should you use?

Accepted Answer

Bubble map with bubble size set to a measure. The bubble map with size set to a measure allows distinguishing overlapping points. Option A is incorrect because ArcGIS maps also show points and can have overlapping issues. Option C is incorrect because filled maps display regions, not individual points. Option D is incorrect because shape maps display regions, not points.

Answer

ArcGIS map

Answer

Filled map

Answer

Shape map

Question 10

You are creating a Power BI report that includes a scatter chart with many data points. Users want to identify outliers quickly. Which approach should you recommend?

Accepted Answer

Add a trend line to the scatter chart and use analytics pane to highlight outliers. Adding a trend line to a scatter chart helps visualize the overall pattern, and the analytics pane in Power BI includes features to highlight outliers, such as outlier detection or highlighting points that fall outside a certain range. This directly supports the user's goal of quickly identifying outliers. Option B (line chart) is more suited for trends over time, not for spotting outliers in scatter data. Option C (table with conditional formatting) can highlight high values but is not as immediate for outlier detection in a scatter plot. Option D (histogram) shows distribution frequencies but does not highlight individual outliers.

Answer

Use a line chart to see spikes

Answer

Add a table with conditional formatting to show high values

Answer

Convert to a histogram to see distribution

Question 11

Refer to the exhibit. You have a DAX measure that ranks products by sales amount. When you add this measure to a table visual with ProductID and Sales Amount, you notice that the rank resets for each year when you add a Year slicer. What should you modify to ensure ranking is always across all products regardless of slicer?

Accepted Answer

Change ALL to ALL(Sales) and add a filter to ignore year. The original measure likely uses ALL(Sales[ProductID]) to rank products, but the Year slicer still filters the Sales table, causing rank to reset per year. By changing to ALL(Sales) and adding a filter to ignore the Year slicer, all filters on the Sales table are removed, ensuring ranking is across all products regardless of slicer selections. Option A (ALLSELECTED) respects the slicer, so it would not ignore the Year filter. Option B (ALLEXCEPT) keeps all filters except the specified column, which would not ignore the Year slicer. Option D (VALUES) respects the slicer filter, so rank would still reset.

Answer

Change ALL to ALLSELECTED(Sales[ProductID])

Answer

Change ALL to ALLEXCEPT(Sales, Sales[Year])

Answer

Change ALL to VALUES(Sales[ProductID])

Question 12

You are designing a Power BI report page. Which two actions can you take to improve the accessibility of the report?

Accepted Answer

Add data labels to visuals. Options C and D are correct. Adding data labels to visuals improves accessibility by making data points more readable for users with visual impairments. Using a high-contrast theme ensures sufficient color contrast, benefiting users with low vision. Option A is incorrect because a dark background with light text can be accessible if contrast is sufficient, but it is not a guaranteed improvement; the recommended approach is to use a high-contrast theme. Option B is incorrect because images, when used with appropriate alt text, can enhance accessibility rather than detract. Option E is incorrect because tooltips provide additional context and accessibility features; removing them can actually reduce accessibility.

Answer

Use a dark background with light text

Answer

Avoid using images in visuals

Answer

Remove all tooltips to reduce clutter

Question 13

You are creating a Power BI report that uses a composite model with DirectQuery and imported tables. Which two considerations should you keep in mind?

Accepted Answer

Some DAX functions may have limitations when used across storage modes. In a composite model, DAX functions that require data to be in-memory (like time intelligence functions) may not work correctly when referencing DirectQuery tables, as those tables remain in the source database. Additionally, certain DAX functions (e.g., `DISTINCTCOUNT`, `VALUES`) can behave differently or have restrictions when used across storage modes, such as returning limited results or requiring specific filter contexts.

Answer

Relationships can only be defined between tables of the same storage mode

Answer

DirectQuery tables cannot be related to imported tables

Answer

All measures must be created in the imported tables

Question 14

You have a Power BI report that includes a line chart showing monthly sales. You want to add a forecast for the next six months. Which feature should you use?

Accepted Answer

Analytics pane. The Analytics pane in Power BI provides built-in forecasting capabilities for time-series data. By selecting a line chart and adding a forecast from the Analytics pane, you can configure the forecast length (e.g., six months), confidence intervals, and seasonality, enabling predictive analysis directly within the visual.

Answer

Filter pane

Answer

Format pane

Answer

Visualization pane

Question 15

You are designing a Power BI report for a sales team. They need to see their individual performance compared to team averages. You have a table with columns: Salesperson, Region, SalesAmount. Which visual best allows each salesperson to see their own value alongside the average?

Accepted Answer

Combo chart (clustered column and line) with salesperson bars and average line. A combo chart with clustered columns for each salesperson and a line for the average allows direct visual comparison of individual performance against the team average. Option A is incorrect because a clustered bar chart can show individual values but adding an average line requires extra measures and is not as immediate. Option B is incorrect because a waterfall chart is designed to show cumulative changes over time, not comparisons to an average. Option C is incorrect because a table with conditional formatting can display values but does not provide an easy visual comparison to the average.

Answer

Clustered bar chart with a measure for average

Answer

Waterfall chart

Answer

Table with conditional formatting