PL-300 Microsoft Power BI Data Analyst Free Practice Exam Questions (2025 Updated)

"The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data" => one dataset and two separate workspaces Reason: All data can be imported into one dataset also if these are two logical models. Shared dimensions can be reconsumed in both models. Reports and additional materials can be shared to the board with an app. The "profit and loss" data model needs RLS for the analysts and the analysts must have just read access to the original workspace. In a separate workspace with contributer (or more rights) they can create new reports (with live connection to the dataset). It is also stated that the new reports mustn't be shared so therefore no need to include them into the app. Import vs. DirectQuery: Due to RLS requirements an imported dataset is needed. It is not possible with file sources and Sharepoint lists.

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

Composite Model means now you can have a model, that very large tables of that are coming from the DirectQuery connection, without the need for importing, and small tables to be imported to be accessible quickly.

Box 1: many-to-one

Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.

The Suppliers table has a Region column.

Box 2: Suppliers table

Use Power Query to calculate calendar quarter and calendar month.

Scenario:

A single dataset must support all three reports:

- The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.

- The Top Products report will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product category.

The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements.

Box 1: Top N

Scenario: The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.

Once you drag to SKU to Visual level filter you should get Top N option

Note: The two most common filter types: automatic and manual.

Then there are more advanced filters.

Box 2: Visual

Once you drag to SKU to Visual level filter you should get Top N option.

Box 1: CALCULATE

CALCULATE evaluates an expression in a modified filter context.

Syntax: CALCULATE([, [, [, …]]])

Expression - The expression to be evaluated.

filter1, filter2,… (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions.

Box 2: FILTER

FILTER returns a table that represents a subset of another table or expression.

Syntax: FILTER(

)

Table- The table to be filtered. The table can also be an expression that results in a table.

Filter - A Boolean expression that is to be evaluated for each row of the table. For example, [Amount] > 0 or [Region] = "France"

Box 3: Orders[ShippedDate]> Orders[RequiredDate]

Northwind Traders defines late orders as those shipped after the required shipping date.

[Reference:, https://docs.microsoft.com/en-us/dax/calculate-function-dax, , https://docs.microsoft.com/en-us/dax/filter-function-dax, , , ]

Question # 59

You need to create a relationship in the data model for RLS.

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

NOTE: Each correct selection is worth one point.

View Answer Next Question

The Answer Is:

Answer:

Question # 60

You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.

For each of the following statement, select Yes if the statement is true, Otherwise, select No.

NOTE: Each correct selection is worth one point.

View Answer Next Question

The Answer Is:

Answer:

Question # 61

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

A.

Merge queries

B.

Append queries

C.

Combine files

View Answer Next Question

The Answer Is:

A

Question # 62

You need to create the semantic model.

Which storage mode should you use for the tables in the semantic model?

A.

live connection

B.

Dual

C.

Import

D.

DirectQuery

View Answer Next Question

The Answer Is:

C

Question # 63

You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.

Which type of visualization should you create?

A.

bar chart

B.

scatterplot

C.

pie chart

View Answer Next Question

The Answer Is:

A

Good news! This question has an explanation. Do you want to see it?

View Explanation

Explanation:

Scenario: The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:

The percentage of orders that were shipped late by country and shipping region

Customers that had multiple late shipments during the last quarter

Note: Bar and column charts are some of the most widely used visualization charts in Power BI. They can be used for one or multiple categories. Both these chart types represent data with rectangular bars, where the size of the bar is proportional to the magnitude of data values.

The difference between the two is that if the rectangles are stacked horizontally, it is called a bar chart. If the rectangles are vertically aligned, it is called a column chart.

[Reference:, https://www.pluralsight.com/guides/bar-and-column-charts-in-power-bi, , , ]

Question # 64

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 whereusername = UserName()

B.

Create a security role that has a table filter on the Region_Manager table wheresales_manager_id = UserPrincipalName().

C.

Create a security role that has a table filter on the Sales_Manager table wherename = UserName().

D.

Create a security role that has a table filter on the Sales_Manager table whereusername = sales_manager_id.

View Answer Next Question

The Answer Is:

A

Good news! This question has an explanation. Do you want to see it?

View Explanation

Explanation:

https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/

Question # 65

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

What should you create?

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]

View Answer Next Question

The Answer Is:

A

Good news! This question has an explanation. Do you want to see it?

View Explanation

Explanation:

Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.

[Reference:, https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand, , ]

Microsoft PL-300 Premium Access     Download Demo    

Page: 3 / 4
Total 464 questions

• Prev
• Next

×

First Try then Buy

✔ PL-300 All Real Exam Questions

✔ PL-300 Exam easy to use and print PDF format

✔ Cover All syllabus and Objectives

✔ Download Free PL-300 Demo (Try before Buy)

✔ Free Frequent Updates

✔ 100% Passing Guarantee by Exam Collection

Close

• Home
• All Products
• About us
• Guarantee
• Testimonials
• Contact us
• FAQs
• DMCA & Copyrights

---

Copyright © 2014-2025 Solution2Pass. All Rights Reserved