Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Microsoft PL-300 - Microsoft Power BI Data Analyst

Microsoft PL-300 Premium Access     Download Demo    
Page: 3 / 5
Total 459 questions

You need to create a Power Bl report. The first page or the report must contain the following two views:

* Sales By Postal Code

* Sales by Month

Both views must display a slicer to select a value for a field named Chain.

The Sales By Postal Code view must display a map visual as shown in the following exhibit.

You need to create a relationship in the dataset for RLS.

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

NOTE: Each correct selection is worth one point.

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.

You need to minimize the size of the semantic model. The solution must meet the report requirements.

What should you do?

A.

Filter out discontinued products while importing the Products table.

B.

Group the Categories table by the CategorylD column.

C.

Change the OrderlD column in the Orders table to the Text data type.

D.

Remove the QuantityPerUnit column from the Products table.

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

You need to create a measure that will return the percentage of late orders.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.