Microsoft PL-300 - Microsoft Power BI Data Analyst

Microsoft PL-300 Premium Access Download Demo

Page: 6 / 6
Total 464 questions

Question # 51

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 # 52

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.

Question # 53

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.

Add the Weekly_Returns data to the Sales table by using related DAX functions.

Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.

Question # 54

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 # 55

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.

Question # 56

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'

import that uses a Microsoft account

DirectQuery that uses the end-user s credentials

DirectQuery that uses a database credential

Import that uses a database credential

Question # 57

You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

an additional date table named ShipDate, a one-to-many relationship fromSales[sales_date_id] to Date[date_id], and a one-to-many relationship fromSales[sales_ship_date_id] to ShipDate[date_id]

an additional date table named ShipDate, a many-to-many relationship fromSales[sales_date_id] to Date[date_id], and a many-to-many relationship fromSales[sales_ship_date_id] to ShipDate[date_id]

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]

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

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]