Practice PL-300 Exam Online

Question 1

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A : Sync the slicers across the pages.

B : Replace the slicers with page-level filters.

C : Replace the slicers with visual-level filters.

D : Create a bookmark for each slicer value.

E : Replace the slicers with report-level filters.

Answer: A,E

Question 2

You plan to use Power BI to import data from 2013 to 2015. Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series. Start of repeated scenario You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

You plan to use Power BI to import data from 2013 to 2015. Product Subcategory [Subcategory] contains NULL values. End of repeated scenario. You implement the Power BI model. You need to add a new column to the Product Subcategory table that uses the following formula. =if [Subcategory] =null then “NA” else [Subcategory] Which command should you use in Query Editor?

A : Column From Examples

B : Custom Column

C : Invoke Custom Function

D : Conditional Column

Answer: D

Question 3

You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?

A : Create a security role that has a table filter on the Sales_Manager table where username = UserName()

B : Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().

C : Create a security role that has a table filter on the Sales_Manager table where name = UserName().

D : Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.

Answer: A

Question 4

You have a Power BI data model that imports a date table and a sales table from an Azure SQL

database data source. The sales table has the following date foreign keys.

Due Date

Order Date

Delivery Date

You need to support the analysis of sales over time based on all three dates at the same time.

Solution: From the Data pane, you rename the date table as Due Date. You use a DAX expression to

create Order Date and Deliver Date as calculated tables. You create active relationships between the

sales table and each date table.

Does this meet the goal?

A : Yes

B : No

Answer: B

Question 5

You have a Power Bi report for the procurement department. The report contains data from the following tables

There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table.

You need to minimize the size of the dataset without affecting the visuals. What should you do?

A : Remove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last month

B : Merge Suppliers and Uneltems.

C : Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price).

D : Remove the Lineitems[Description] column.

Answer: D

Name:	Microsoft Certified Power BI Data Analyst Associate
Exam Code:	PL-300
Certification:	Data Analyst Associate
Vendor:	Microsoft
Total Questions:	465
Last Updated:	Oct 01, 2026

Microsoft PL-300 Answers