What should you do next to meet the reporting requirements of the executives?

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region .

What should you do next to meet the reporting requirements of the executives?
A . Apply row-level security (RLS) to the Region table based on the sales manager username.
B. Configure a bi-directional relationship between Region and Sales.Region.
C. Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.
D. In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

View Answer

Answer: C