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. Create a DAX calculated column that retrieves the region manager from the Weekly_Returns table based on the sales_region_id column.

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

C. Configure a bi-directional relationship between Region and Sales_Region.

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








 

Suggested Answer: A

Executives require a visual that shows returns by region manager and the sales managers that report to them.
A hierarchy is a set of fields categorized in a hierarchical way that one level is the parent of another level. Values of the parent level can be drilled down to the lower level.
Reference:
https://radacad.com/what-a-power-bi-hierarchy-is-and-how-to-use-it

This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.