Cyber Monday Special Sale - 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: best70

Page: 1 / 7
Total 70 questions
Exam Code: PL-300                Update: Dec 7, 2025
Exam Name: Microsoft Power BI Data Analyst

Microsoft Microsoft Power BI Data Analyst PL-300 Exam Dumps: Updated Questions & Answers (December 2025)

Question # 1

You have a Fabric workspace named Workspace1 that contains two Power Bl reports named Report1 and Report2.

You create a workspace app that contains both reports.

You need to ensure that the app meets the following requirements:

• Report1 must be visible to all the users in your organization.

• Report2 must be visible to only a security group named Group1.

What should you do next?

A.

Assign Group1 the Viewer role for Workspace1.

B.

Share Report1 with the built-in All users security group.

C.

Create an audience and assign Group1 to the audience.

D.

Allow access to the hidden content of the app.

Question # 2

You have a Power Bl report.

You have the following tables.

You have the following DAX measure.

Question # 3

You have an on-premises data gateway.

You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

Solution: You decrease the dashboard cache update frequency.

Does this meet the goat?

A.

Yes

B.

No

Question # 4

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.

You need to create a reference line to show which employees are above the median salary.

Solution: You create a median line by using the Salary measure.

Does this meet the goal?

A.

Yes

B.

No

Question # 5

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]

Question # 6

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?

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.

Question # 7

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

A.

Select Column distribution.

B.

Select the sales_amount column and apply a number filter.

C.

Select Column profile, and then select the sales_amount column.

D.

Transform the sales_amount column to replace negative values with 0.

Question # 8

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'

A.

import that uses a Microsoft account

B.

DirectQuery that uses the end-user s credentials

C.

DirectQuery that uses a database credential

D.

Import that uses a database credential

Question # 9

You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

A.

Change the data type of Sales[region_id] to Whole Number.

B.

In the Sales table, add a measure for sum(sales_amount).

C.

Change the data type of sales[sales_id] to Text.

D.

Change the data type of sales [region_id] to Decimal Number.

Question # 10

You publish the semantic model to powerbi.com.

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

NOTE: Each correct selection is worth one point.

Page: 1 / 7
Total 70 questions

Most Popular Certification Exams

Payment

       

Contact us

dumpscollection live chat

Site Secure

mcafee secure

TESTED 07 Dec 2025