Logo ExamsQA
Exit
Official Bank 0/464

Microsoft Power BI Data Analyst (PL-300) - Microsoft Exam Questions

Last updated on June 22, 2026

97% Exam Compliance
464 Total Questions
1
Question
following table. You have a table named DiMCountries that contains a column named Country as shown in the

Exhibit

You plan to use DiMCountnes as a dimension m a report. You new to ensure that the Country column in DiMCountnes lists each country only once. Which two actions should you perform on the Country column? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.
Select 2
Options
A Apply a clean transform.
B Change Data category to Country.
C Replace the empty fields.
D Apply a Capitalize Each Word transform.
E Remove duplicate values.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
HOTSPOT You use Power Query Editor to review a query that contains a column named Country.

You need to view the following information in the Data preview view for the Country column:

• The percentage of values that contain errors.

• The count of empty values.
What should you enable? To answer, select the appropriate options in the answer are

Exhibit
HOTSPOT
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
You have a semantic model that has the permissions shown in the following exhibit. HOTSPOT

Exhibit

Use the drop-down menus to select the answer choice the that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Exhibit
Reveal Only
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?
Options
A Share each report to the Azure Active Directory group of the sales department.
B Add the sales department as a member of the reports workspace
C Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.
D Distribute an app to the users in the Azure Active Directory group of the sales department.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
You have a Power BI model that contains a table named Sales. The Sales table contains the following columns:

• Order Line ID

• Product ID

• Unit Price

• Order ID

• Quantity
Orders are uniquely identified by using the order ID and can have multiple order lines Each order line within an order contains a different product ID. You need to write a DAX measure that counts the number of orders.

Which formula should you use?
Options
A DistinctCount (sales'[Order ID])
B CountRows('Sales')
C Count ('Sales'(Order ID])
D CountA (Sale** (Order ID])
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.