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

Question 1

You have a Power BI report that shows sales by product category. The report is used by the sales team, who need to see the data at a regional level. You want to allow users to switch between viewing data for all regions and a specific region without creating multiple pages. Which feature should you use?

Accepted Answer

Use bookmarks with a region slicer.. Option B is correct because bookmarks allow you to capture different states of a report page (e.g., with a specific slicer selection) and let users switch between them. Option A is wrong because drillthrough navigates to a different page. Option C is wrong because tooltips show additional info on hover. Option D is wrong because Q&A is a natural language query feature.

Answer

Add a tooltip page that shows regional data.

Answer

Create drillthrough pages for each region.

Answer

Enable the Q&A visual and let users type the region.

Question 2

You are designing a Power BI report to analyze customer churn. The data model includes a 'Customers' table and a 'Churn' table. You need to create a measure that calculates the churn rate for each month, defined as the number of customers who churned that month divided by the total number of active customers at the beginning of the month. What is the best approach?

Accepted Answer

Create a calculated table that summarizes active customers at the start of each month.. Option C is correct because a churn rate requires a snapshot of active customers at the start of each month, which is best achieved with a calculated table that shows the count per month. Option A is wrong because a calculated column would be static and not respect month boundaries. Option B is wrong because RANKX is unrelated. Option D is wrong because a simple measure would not properly handle the denominator.

Answer

Write a measure using COUNTROWS and FILTER.

Answer

Use the RANKX function to order customers by churn date.

Answer

Create a calculated column in the 'Customers' table to mark churned status per month.

Question 3

You have a Power BI report that uses a live connection to an Azure Analysis Services (AAS) tabular model. You need to add a new measure to the report. What should you do?

Accepted Answer

Add the measure to the AAS tabular model using SQL Server Management Studio (SSMS) or Visual Studio.. Option A is correct because with a live connection, you cannot create measures in Power BI Desktop; they must be defined in the source model. Option B is wrong because measures cannot be created in the report layer with live connection. Option C is wrong because calculated columns also cannot be added. Option D is wrong because the AAS model must be modified externally.

Answer

Use DAX to create a new calculated column in Power BI Desktop.

Answer

Modify the AAS model directly from Power BI Desktop.

Answer

Create a new calculated table in Power BI Desktop.

Question 4

You have a Power BI report with a date table and a sales table. The above DAX measure is used in a visual that also shows 'Date[Year]' on the axis. What does this measure return?

Accepted Answer

The sum of sales for the maximum year present in the Date table, regardless of the visual's year filter.. Option C is correct because the FILTER with ALL(Date) removes all filters from the Date table, then keeps only rows where Year equals the maximum year in the current context (which, because of the ALL, is the maximum year in the entire Date table regardless of slicers). Since the visual is filtered to a specific year by the axis, the measure shows the total for the max year overall, not the current year. Option A is wrong because it would require ALLSELECTED or no ALL. Option B is wrong because it would be a simple SUM. Option D is wrong because the measure returns a sum, not a blank.

Answer

The sum of sales for all years.

Answer

The sum of sales for the current year on the axis.

Answer

A blank because the measure conflicts with the visual filter.

Question 5

You have a Power BI dataset that includes a 'Sales' table and a 'Calendar' table. You need to create a measure that calculates the running total of sales over the last 12 months, ending on the last date in the current filter context. Which DAX function should you use?

Accepted Answer

DATESINPERIOD. Option B is correct because DATESINPERIOD returns a set of dates from the last date in the current context going back 12 months, which is ideal for a rolling 12-month total. Option A is wrong because DATEADD shifts dates but does not automatically give a period. Option C is wrong because DATESBETWEEN requires explicit start and end dates. Option D is wrong because PREVIOUSMONTH only gives one month.

Answer

DATEADD

Answer

PREVIOUSMONTH

Answer

DATESBETWEEN

Question 6

You are building a Power BI report to display sales data. You want to ensure that when users export the report data to Excel, the exported data respects the current filters and slicers applied in the report. What should you do?

Accepted Answer

Use the 'Export data' option from the visual's context menu.. Option D is correct because the 'Export data' feature in Power BI respects the current filters and slicers by default. Options A and B are about underlying data permissions, not export filtering. Option C is about preventing export, not filtering behavior.

Answer

Apply row-level security (RLS) to the dataset.

Answer

Set the report to 'Read only' mode.

Answer

Use the 'Analyze in Excel' feature.

Question 7

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.. Option B is correct because the Power BI Query Editor (Power Query) includes a 'Merge Queries' feature that allows you to join two tables based on matching values in a common column. This is a fundamental data transformation operation used to combine data from different sources or tables before loading into the data model.

Answer

Define row-level security (RLS) roles.

Answer

Create a relationship between two tables.

Answer

Create a new measure using DAX.

Question 8

Which THREE of the following are valid considerations when using Power BI's AI visuals? (Choose three.)

Accepted Answer

Some AI visuals have a limit on the number of data points they can analyze.. Options A, B, and C are correct. Option A is correct because AI visuals (like Key Influencers) have data limits. Option B is correct because some AI visuals require Premium capacity for advanced features. Option C is correct because AI visuals may need a specific column type (e.g., numeric for decomposition tree). Option D is wrong because AI visuals do not require a separate license beyond Power BI. Option E is wrong because AI visuals are not deprecated.

Answer

AI visuals are only available with an AI workload license.

Answer

AI visuals are deprecated in favor of Copilot.

Question 9

Which TWO of the following are valid ways to share a Power BI report with external users who do not have a Power BI license? (Choose two.)

Accepted Answer

Publish the report to a Power BI app and grant access to external users if the tenant settings allow.. Options B and C are correct. Option B allows external users to view reports with a Pro license if the tenant allows. Option C allows sharing via a link that works without a license (but requires appropriate settings). Option A is wrong because sharing directly requires the recipient to have a Pro license. Option D is wrong because exporting via email is not a built-in feature. Option E is wrong because sharing to a distribution group still requires licenses.

Answer

Export the report to PDF and email it to the external user.

Answer

Share the report directly from the Power BI service by entering the external user's email address.

Answer

Add the external user to a distribution group and share the report with that group.

Question 10

You receive the above JSON policy for a Power BI dataset. You need to add a relationship between the 'Sales' table and a 'Calendar' table in the same dataset. What must you modify in the JSON?

Accepted Answer

Add an object to the 'relationships' array.. Option B is correct because relationships are defined in the 'relationships' array within the dataset. Option A is wrong because the 'tables' array holds table definitions, not relationships. Option C is wrong because measures are separate. Option D is wrong because the dataset version is metadata, not a place for relationships.

Answer

Add a new table to the 'tables' array.

Answer

Change the 'version' field to '2.0'.

Answer

Add a measure that references the Calendar table.

Question 11

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?

Accepted Answer

Add a slicer to limit the data range.. Option B is correct because filtering reduces the amount of data queried from the source, improving performance. Option A is wrong because increasing the number of data points worsens performance. Option C is wrong because disabling cross-filtering does not reduce the data volume. Option D is wrong because changing to Import would require a full data load, which may not be feasible for large data.

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 12

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. Option C is correct because a line chart is ideal for showing trends over time. Option A is wrong because a pie chart shows proportions. Option B is wrong because a table shows raw data. Option D is wrong because a card shows a single value.

Answer

Pie chart

Answer

Card

Answer

Table

Question 13

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 14

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.. Option B is correct because 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). This ensures that interactive elements receive focus in a meaningful order, directly improving accessibility for users with motor disabilities or those relying on screen readers.

Answer

Add animations to visuals to draw attention.

Answer

Use a high contrast theme.

Question 15

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.