PL-300 Practice Test 27 — 15 Questions

Question 1

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

Accepted Answer

The ALL('Date') function removes the filter context, so the calculation returns total sales for all dates.. Option B is correct because ALL('Date') removes all date filters, causing the CALCULATE to ignore the date filter context. Option A is wrong because VAR does not affect the result. Option C is wrong because relationship direction does not cause this specific issue. Option D is wrong because ALL does not cause circular dependency.

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 2

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?

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 3

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

Accepted Answer

Box and whisker plot. A and D are correct for distribution. B is for correlation, C is for parts of a whole, and E is for comparing categories.

Answer

Pie chart

Answer

Scatter chart

Answer

Bar chart

Question 4

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"). Option A is correct because CALCULATE modifies the filter context to include only 'Electronics' category. Option B is wrong because it sums over the Products table, not Sales. Option C is wrong because it sums the entire Sales table without filter. Option D is wrong because it uses RELATED incorrectly.

Answer

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

Answer

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

Answer

SUM(Sales[Amount])

Question 5

You have a Power BI report that uses a live connection to an Azure Analysis Services (AAS) model. Users report that the report takes a long time to load when they apply a slicer on a calculated column. What should you recommend?

Accepted Answer

Convert the calculated column to a measure if the logic allows. Calculated columns are evaluated at refresh time and stored in memory. They can degrade performance. Option B is correct: convert to a measure if possible. Option A is wrong because incremental refresh is for imports, not live connections. Option C is wrong because disabling interactions would hide the issue. Option D is wrong because calculated columns are not faster.

Answer

Replace the calculated column with a calculated table

Answer

Implement incremental refresh on the calculated column

Answer

Disable cross-filtering between the slicer and the visual

Question 6

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. Option B is correct: Use Azure AD B2B guest accounts. Option C is correct: Publish to Power BI Report Server (on-premises) allows anonymous access or forms auth. Option A is wrong: Publish to web makes the report public. Option D is wrong: Email subscription sends a snapshot, not interactive. Option E is wrong: Embed in SharePoint requires internal users.

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 7

You have a Power BI report that uses a measure with a filter context. You want to override the filter context for a specific calculation. Which function should you use?

Accepted Answer

CALCULATE. Option D is correct because CALCULATE changes filter context. Option A is wrong because FILTER returns a table. Option B is wrong because ALL removes filters. Option C is wrong because VALUES returns distinct values.

Answer

ALL

Answer

FILTER

Answer

VALUES

Question 8

You have a Power BI report with the DAX measure shown in the exhibit. Users report that the measure returns blank for some months even though sales data exists for both current and previous years. What is the most likely cause?

Accepted Answer

The 'Date' table is not marked as a date table or is missing dates.. Option A is correct because SAMEPERIODLASTYEAR requires a contiguous date table marked as a date table; if the date table does not cover all dates, it may return blank. Option B is wrong because DIVIDE handles division by zero gracefully. Option C is wrong because the measure uses SUM which aggregates correctly. Option D is wrong because relationship direction affects filtering but not SAMEPERIODLASTYEAR's ability to shift dates.

Answer

The measure uses SUM instead of SUMX.

Answer

The DIVIDE function is incorrectly handling division by zero.

Answer

The relationship between 'Sales' and 'Date' is set to cross-filter direction single.

Question 9

You need to create a visual that displays the sales trend over the last 12 complete months. Which approach should you use?

Accepted Answer

Use a relative date filter on the date field set to 'Last 12 months'.. Option C is correct because a relative date filter on a date hierarchy shows the last N periods. Option A is wrong because a slicer requires manual selection. Option B is wrong because a calculated column is static. Option D is wrong because a measure alone does not filter visuals.

Answer

Create a calculated column that flags last 12 months.

Answer

Add a slicer for the last 12 months.

Answer

Write a measure that calculates sales for last 12 months and use it in a visual.

Question 10

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. Option D is correct because in DirectQuery mode, queries are sent to the source; creating an index on the region column will speed up filtering. Option A is wrong because Import mode is not always feasible or desired. Option B is wrong because increasing cache size does not help DirectQuery. Option C is wrong because reducing cardinality would lose information.

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

Question 11

You have a report page that shows sales by region. You want users to be able to select a region and see the corresponding sales details on the same page without navigating away. Which feature should you use?

Accepted Answer

Slicer. Option A is correct because a slicer filters the entire page based on the selected value, showing details on the same page. Option B is wrong because drillthrough navigates to a different page. Option C is wrong because a card visual only shows a single value. Option D is wrong because a matrix with expand/collapse is for hierarchical display, not cross-filtering.

Answer

Drillthrough

Answer

Matrix with expand/collapse

Answer

Card visual

Question 12

You are building a Power BI report that shows sales by region. You want to use a visual that displays hierarchical data, such as region -> country -> city, and allows drilling up and down. Which visual should you use?

Accepted Answer

Decomposition tree. Option A is correct because the decomposition tree visual is designed for hierarchical drilling and root cause analysis. Option B is wrong because a stacked bar chart does not support hierarchical drill-down natively. Option C is wrong because a scatter plot shows relationships between two numeric variables. Option D is wrong because a card visual shows a single value.

Answer

Scatter plot

Answer

Stacked bar chart

Answer

Card

Question 13

You are designing a Power BI dashboard for executive management. Which TWO practices should you follow to ensure the dashboard is effective?

Accepted Answer

Use consistent color coding across visuals.. Options A and D are correct. A: Using consistent color coding helps users quickly interpret data. D: Including key KPIs focuses on what matters. Option B is wrong because too many visuals clutter the dashboard. Option C is wrong because real-time refresh may not be necessary and can impact performance.

Answer

Configure real-time data refresh for all data sources.

Answer

Include as many visuals as possible on a single dashboard page.

Answer

Use a dark background to make visuals stand out.

Question 14

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.. Option A is correct because Power BI can connect to Excel files in SharePoint via the SharePoint Folder connector, and then schedule refresh. Option B is wrong because importing to Power Query is not a data source; it's a transformation step. Option C is wrong because manual uploads do not support scheduled refresh. Option D is wrong because Excel Online is not a direct data source for Power BI refresh.

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 15

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. Option C is correct because adding a trend line and highlighting outliers helps identify them. Option A is wrong because a table is not visual. Option B is wrong because a line chart is for trends. Option D is wrong because a histogram shows distribution, not outliers individually.

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

PL-300 Practice Test 27 — 15 Questions

Exhibit

PL-300 Practice Test 27 — 15 Questions

Exhibit