Exactprep PL-300 Questions

Microsoft Power BI Data Analyst Questions and Answers

Question 45

How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question 46

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

What should you include in the solution?

Create a security role that has a table filter on the Sales_Manager table whereusername = UserName()

Create a security role that has a table filter on the Region_Manager table wheresales_manager_id = UserPrincipalName().

Create a security role that has a table filter on the Sales_Manager table wherename = UserName().

Create a security role that has a table filter on the Sales_Manager table whereusername = sales_manager_id.

Question 47

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

Question 48

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

Select Column distribution.

Select the sales_amount column and apply a number filter.

Select Column profile, and then select the sales_amount column.

Transform the sales_amount column to replace negative values with 0.