Microsoft Updated PL-300 Exam Questions and Answers by bianca

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.

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.

a measure that uses a formula of SUM (Sales [sales_id])

a calculated column that use a formula of COUNTA(sales [sales_id])

a measure that uses a formula of COUNTROWS (Sales)

a calculated column that uses a formula of SUM (Sales [sales_id])

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]