Pre-Winter Sale 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

Free Microsoft PL-300 Practice Exam with Questions & Answers | Set: 6

Questions 51

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.

What should you recommend?

Options:
A.

Create a shared dataset for each standardized entity.

B.

Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.

C.

For every report, create and use a single shared dataset that contains the standardized data.

D.

For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.

Microsoft PL-300 Premium Access
Questions 52

How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

PL-300 Question 52

Options:
Questions 53

Which DAX expression should you use to get the ending balances in the balance sheet reports?

Options:
A.

CALCULATE (SUM( BalanceSheet [BalanceAmount] ),DATESQTD( 'Date'[Date] ))

B.

CALCULATE (SUM( BalanceSheet [BalanceAmount] ),LASTDATE( 'Date'[Date] ))

C.

FIRSTNONBLANK ( 'Date' [Date]SUM( BalanceSheet[BalanceAmount] ))

D.

CALCULATE (MAX( BalanceSheet[BalanceAmount] ),LASTDATE( 'Date' [Date] ))

Questions 54

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

PL-300 Question 54

Options:
Questions 55

What is the minimum number of datasets and storage modes required to support the reports?

Options:
A.

two imported datasets

B.

a single DirectQuery dataset

C.

two DirectQuery datasets

D.

a single imported dataset

Questions 56

You need to grant access to the business unit analysts.

What should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

PL-300 Question 56

Options:
Questions 57

You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales You need to create a measure that calculates the total sales from the equivalent month of the previous year.

How should you complete the calculation? To answer, select the appropriate options in the answer area

NOTE: Each correct selection is worth one point.

PL-300 Question 57

Options:
Questions 58

You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

Options:
A.

an additional date table named ShipDate, a one-to-many relationship fromSales[sales_date_id] to Date[date_id], and a one-to-many relationship fromSales[sales_ship_date_id] to ShipDate[date_id]

B.

an additional date table named ShipDate, a many-to-many relationship fromSales[sales_date_id] to Date[date_id], and a many-to-many relationship fromSales[sales_ship_date_id] to ShipDate[date_id]

C.

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]

D.

a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-manyrelationship from Sales[sales_ship_date_id] to Date[date_id]

E.

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]

Questions 59

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

Options:
A.

In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.

B.

Add the Weekly_Returns data to the Sales table by using related DAX functions.

C.

Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.

Questions 60

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?

Options:
A.

Apply row-level security (RLS) to the Region table based on the sales manager username.

B.

Configure a bi-directional relationship between Region and Sales.Region.

C.

Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.

D.

In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

Exam Code: PL-300
Certification Provider: Microsoft
Exam Name: Microsoft Power BI Data Analyst
Last Update: Nov 19, 2025
Questions: 464

Microsoft Related Exams

DP-420 - Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB
MB-700 - Microsoft Dynamics 365: Finance and Operations Apps Solution Architect
MB-820 - Microsoft Dynamics 365 Business Central Developer
AZ-204 - Developing Solutions for Microsoft Azure
AZ-120 - Planning and Administering Microsoft Azure for SAP Workloads
SC-401 - Administering Information Security in Microsoft 365
62-193 - Technology Literacy for Educators
77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation
MB-910 - Microsoft Dynamics 365 Fundamentals Customer Engagement Apps (CRM)
AZ-104 - Microsoft Azure Administrator
77-420 - Excel 2013
MS-102 - Microsoft 365 Administrator Exam
GH-900 - GitHub Foundations
MB-330 - Microsoft Dynamics 365 Supply Chain Management
PL-600 - Microsoft Power Platform Solution Architect
Microsoft Free Access
Get Microsoft Full Access

Microsoft Free Exams
Microsoft Free Exams
Prepare effectively for Microsoft certification exams with free study resources and practice tests from Examstrack.