You work as a database administrator at ABC.com. The ABC.com network consists of a single
domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are in the process of developing a SQL Server Master Data Services (MDS) model.
ABC.com’s source data is hosted by a single table. The table includes the manager-to-subordinate
relationships.
You now have to design a hierarchy that suits ABC.com’s organizational structure.
Which of the following actions should you take?
A.
You should consider making use of a Recursive hierarchy type.
B.
You should consider making use of a Non-Mandatory Explicit hierarchy.
C.
You should consider making use of a Mandatory Explicit Hierarchy.
D.
You should consider making use of a Derived Hierarchy with Explicit Caps.
Explanation: