You are creating a SQL Server Master Data Services (MDS) model for a company. The source data for the
company is stored in a single table that contains the manager-to-subordinate relationships. You need to create
a hierarchy representing the organizational structure of the company. Which hierarchy type should you use?
A.
Natural
B.
Explicit
C.
Parent
D.
Recursive
Explanation:
According to these references, this answer looks correct.
Reference: http://technet.microsoft.com/en-us/library/ff487006.aspx
Reference: http://msdn.microsoft.com/en-us/library/ee633747.aspx
Reference: http://technet.microsoft.com/en-us/library/ee633759.aspx
D.
Recursive