Which hierarchy type should you use?

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

View Answer

Answer: D

Explanation:

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/libra ry/ee633759.aspx