Black Friday Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

Sure Pass Exam PL-300 PDF

Page: 13 / 13
Question 52

You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

Options:

A.

Create a security role that has a table filter on the Sales_Manager table where

username = UserName()

B.

Create a security role that has a table filter on the Region_Manager table where

sales_manager_id = UserPrincipalName().

C.

Create a security role that has a table filter on the Sales_Manager table where

name = UserName().

D.

Create a security role that has a table filter on the Sales_Manager table where

username = sales_manager_id.

Question 53

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

Options:

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 54

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

Options:

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 55

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.

Options:

Page: 13 / 13
Exam Code: PL-300
Exam Name: Microsoft Power BI Data Analyst
Last Update: Nov 27, 2024
Questions: 386
PL-300 pdf

PL-300 PDF

$28.5  $94.99
PL-300 Engine

PL-300 Testing Engine

$33  $109.99
PL-300 PDF + Engine

PL-300 PDF + Testing Engine

$43.5  $144.99