Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Microsoft PL-300 - Microsoft Power BI Data Analyst

Page: 5 / 5
Total 459 questions

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.

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.

You need to create a visualization to meet the reporting requirements of the sales managers.

How should you create the visualization? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

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.

What should you create to meet the reporting requirements of the sales department?

A.

a measure that uses a formula of SUM (Sales [sales_id])

B.

a calculated column that use a formula of COUNTA(sales [sales_id])

C.

a measure that uses a formula of COUNTROWS (Sales)

D.

a calculated column that uses a formula of SUM (Sales [sales_id])

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.