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. Organizational
B. Recursive
C. Non-Mandatory Explicit
D. Many-to-Many
E. Natural
F. Explicit
G. Parent

  Discussion forum


Leave an answer