Microsoft Power BI Data Analyst PL-300 Exam Questions with Experts Answers Updated Recently

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.

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.

A.  

an additional date table named ShipDate, a one-to-many relationship from

Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from

Sales[sales_ship_date_id] to ShipDate[date_id]

B.  

an additional date table named ShipDate, a many-to-many relationship from

Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from

Sales[sales_ship_date_id] to ShipDate[date_id]

C.  

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]

D.  

a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many

relationship from Sales[sales_ship_date_id] to Date[date_id]

E.  

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]