Month End Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

All PL-300 Test Inside Microsoft Questions

Page: 7 / 16
Total 422 questions

Microsoft Power BI Data Analyst Questions and Answers

Question 25

You need to create the Top Customers report.

Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 26

You publish the dataset 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.

Options:

Question 27

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

Options:

A.

FORMAT('Date'[date], "MMM YYYY")

B.

FORMAT('Date' [date], "M YY")

C.

FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")

D.

FORMAT('Date' [date_id], "MMM YYYY")

Question 28

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.

Page: 7 / 16
Total 422 questions