Passed Exam Today PL-300

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]

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]

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-many

relationship 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]

Apply row-level security (RLS) to the Region table based on the sales manager username.

Configure a bi-directional relationship between Region and Sales.Region.

Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.

In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

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.