You are creating a SQL Server Master Data Services (MDS) model for a company. The source data for the company is stored
Posted: Mon Oct 17, 2022 4:49 pm
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
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