PL-300 Practice Test 30 — 15 Questions

Question 1

You need to create a Power BI report that shows sales by region and by product category. Users should be able to click on a region and see the sales for that region across all product categories. What is the best way to enable this?

Accepted Answer

Enable cross-filtering between the region slicer and the category chart. Cross-filtering is the simplest method. Option B is correct. Option A is wrong because drillthrough navigates to a detail page. Option C is wrong because tooltips don't change the visual. Option D is wrong because bookmarks require manual setup.

Answer

Set up a drillthrough page that filters by region

Answer

Use a report page tooltip to show category details

Answer

Create a bookmark for each region

Question 2

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 network connection is blocked from reaching AppSource.. Option C is correct because custom visuals require an internet connection to load from the marketplace. Option A is wrong because the visual type is not the issue. Option B is wrong because the visual is certified by the developer. Option D is wrong because security roles in the dataset do not affect visual rendering.

Answer

The visual is not compatible with the report theme.

Answer

The dataset has row-level security applied.

Answer

The visual is not certified by Microsoft.

Question 3

You have the DAX expression shown. It is intended to sum sales for the West region using an inactive relationship. However, the result is incorrect. What is the issue?

Accepted Answer

There may be multiple inactive relationships between Sales and Date, causing ambiguity.. Option B is correct because USERELATIONSHIP activates a relationship, but if there are multiple inactive relationships between the same tables, it might not pick the intended one. Option A is wrong because the syntax is correct. Option C is wrong because the filter is applied correctly. Option D is wrong because there is no ambiguity in the filter.

Answer

The USERELATIONSHIP function syntax is incorrect.

Answer

The filter on Region should be in a separate CALCULATE.

Answer

The column names are case-sensitive and don't match.

Question 4

You need to design a report that allows users to see sales data at the year, quarter, and month levels, with the ability to expand and collapse hierarchies. Which visual type should you use?

Accepted Answer

Matrix visual. Option A is correct because matrix visual supports expand/collapse hierarchies. Option B is wrong because a bar chart does not have hierarchy expansion built-in. Option C is wrong because a table is flat. Option D is wrong because a card visual shows a single value.

Answer

Table visual with hierarchy

Answer

Stacked bar chart with drill-down

Answer

Card visual with hierarchy

Question 5

You need to create a visual that shows the relationship between advertising spend and website traffic. Which type of visual is most appropriate?

Accepted Answer

Scatter chart. Scatter charts are ideal for showing relationships between two numeric variables. A line chart shows trends over time, a bar chart compares categories, and a pie chart shows proportions.

Answer

Stacked bar chart

Answer

Pie chart

Answer

Line chart

Question 6

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

Accepted Answer

Provide descriptive alt text for all visuals. A and D are accessibility best practices. B is wrong because tab order should follow reading order. C is wrong because high contrast is not always better. E is wrong because decorative elements should be marked as decorative.

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 7

Which TWO of the following are valid ways to create a date table in Power BI? (Select two.)

Accepted Answer

Using DAX: DateTable = CALENDARAUTO(). Option A is valid by using CALENDARAUTO. Option D is valid by using Power Query to generate a list of dates. Option B is wrong because CALCULATE is a function, not a table constructor. Option C is wrong because DATESYTD returns a table of dates but only for a year-to-date period, not a full date table. Option E is wrong because SUMMARIZE returns a summary table, not a date table.

Answer

Using DAX: DateTable = DATESYTD('Date'[Date])

Answer

Using DAX: DateTable = CALCULATE(DISTINCT(Sales[Date]))

Answer

Using DAX: DateTable = SUMMARIZE(Sales, Sales[Date])

Question 8

You need to ensure that a Power BI report is accessible to users with visual impairments. Which feature should you configure?

Accepted Answer

Add alt text to each visual.. Option B is correct because Power BI allows adding alt text to visuals, which screen readers can read. Option A is wrong because tab order is for keyboard navigation but not specifically for visual impairments. Option C is wrong because the high-contrast theme affects colors but does not provide textual descriptions. Option D is wrong because data labels are not read by screen readers.

Answer

Apply a high-contrast theme.

Answer

Enable data labels on all visuals.

Answer

Set custom tab order for visuals.

Question 9

You have the measure shown. You add it to a table visual alongside columns from a related table. The total is higher than expected. What is the most likely cause?

Accepted Answer

The visual is expanding the measure due to a many-to-one relationship.. Option B is correct because if the relationship is one-to-many and the visual includes columns from the one side, the measure might be summing across multiple rows due to cross-filtering. Option A is wrong because there is no filter. Option C is wrong because it's a sum. Option D is wrong because the table is not summarized.

Answer

The Sales table is summarized at a different granularity.

Answer

The measure is not filtered by any slicer.

Answer

The measure should use SUMX instead of SUM.

Question 10

Which TWO features can be used to implement row-level security (RLS) in Power BI? (Select TWO.)

Accepted Answer

Static row-level security in Power BI Desktop. Options B and D are correct. Option A is wrong because report page filters apply to all users. Option C is wrong because a slicer does not enforce security. Option E is wrong because a bookmark does not enforce security.

Answer

Bookmarks that hide rows

Answer

Report-level filters

Answer

Slicer with user principal name

Question 11

Your Power BI report uses a custom visual that is not rendering in the Power BI service. The visual works correctly in Power BI Desktop. What is the most likely cause?

Accepted Answer

The custom visual is not certified by Microsoft. Custom visuals from AppSource require approval; if not certified, they may be blocked by admin policies. The data source is irrelevant, and all visuals need to be loaded. Refreshing the browser rarely helps.

Answer

The data source is not supported in the service

Answer

The visual was not imported into the report

Answer

The browser needs to be refreshed

Question 12

You have the DAX measure shown. The measure returns blank for some periods even though there are sales in the current period. What is the most likely cause?

Accepted Answer

The Date table does not contain all dates from the previous year.. Option B is correct because SAMEPERIODLASTYEAR requires a contiguous date table to work correctly; if dates are missing, it returns blank. Option A is wrong because the measure does not have filter context issues by default. Option C is wrong because DIVIDE handles division by zero and returns blank, but the issue is that PreviousSales is blank. Option D is wrong because the measure is not using a variable incorrectly.

Answer

The measure is not properly filtered by the current context.

Answer

The variable CurrentSales is not evaluated correctly.

Answer

The DIVIDE function returns blank when denominator is zero.

Question 13

You are building a report to analyze sales performance by region. You need to allow users to dynamically switch between viewing data as a bar chart and a line chart without modifying the report page. Which feature should you use?

Accepted Answer

Use bookmarks with buttons to toggle between charts.. Option A is correct because bookmarks with buttons allow users to switch between visual states dynamically. Option B is wrong because a slicer filters data, not switches chart types. Option C is wrong because a drillthrough page navigates to a different page. Option D is wrong because a custom visual would require additional development.

Answer

Add a slicer that changes the chart type.

Answer

Use a custom visual with built-in toggle.

Answer

Create a drillthrough page for each chart type.

Question 14

Which THREE actions can help optimize a Power BI report's performance? (Select THREE.)

Accepted Answer

Reduce the number of visuals on a single page.. Options A, C, and D are correct. Option B is wrong because using many calculated columns can hurt performance. Option E is wrong because importing all columns increases model size and refresh time; only import needed columns.

Answer

Use calculated columns instead of measures for complex aggregations.

Answer

Import all columns from source tables to avoid missing data.

Question 15

Refer to the exhibit. You are configuring a Power BI dataset for a real-time dashboard that must show data with no more than 5 minutes of latency. What is the impact of the current query caching setting?

Accepted Answer

It will improve performance but may show data up to 60 minutes old. Query caching stores results for up to 60 minutes, causing data to be up to an hour old. This violates the 5-minute latency requirement. The mode is On, not off, and caching applies to all queries. DirectQuery mode does not eliminate caching.

Answer

It will disable caching for real-time queries

Answer

It will cause the dataset to switch to DirectQuery mode

Answer

It will have no effect because caching is off