Selected PL-300 Microsoft Certified: Power BI Data Analyst Associate Questions Answers

Microsoft Power BI Data Analyst Questions and Answers

Question 33

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

Change the data type of Sales[region_id] to Whole Number.

In the Sales table, add a measure for sum(sales_amount).

Change the data type of sales[sales_id] to Text.

Change the data type of sales [region_id] to Decimal Number.

Question 34

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 where

username = UserName()

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

sales_manager_id = UserPrincipalName().

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

name = UserName().

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

username = sales_manager_id.

Question 35

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 36

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