70-463 · Question #52
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…
The correct answer is D. Recursive. In MDS, a recursive hierarchy is the correct choice when source data contains a self-referencing parent-child relationship within a single table, such as manager-to-subordinate.
Question
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?
Options
- ANatural
- BExplicit
- CParent
- DRecursive
How the community answered
(47 responses)- A2% (1)
- C4% (2)
- D94% (44)
Why each option
In MDS, a recursive hierarchy is the correct choice when source data contains a self-referencing parent-child relationship within a single table, such as manager-to-subordinate.
A natural hierarchy in MDS is derived from the attribute relationships between domains, not from a self-referencing column within a single table.
An explicit hierarchy in MDS requires members to be manually arranged into levels and does not derive structure automatically from a parent-child column in a single table.
'Parent' is not a recognized hierarchy type in SQL Server MDS; the self-referencing structure is specifically called a recursive hierarchy.
A recursive hierarchy in SQL Server MDS is specifically designed for self-referencing relationships where a single table contains both parent and child members linked by a common attribute (e.g., ManagerID referencing EmployeeID). This structure allows the hierarchy to represent an unlimited number of levels without requiring additional tables or explicit level definitions. It is the standard MDS approach for organizational charts stored in a single table.
Concept tested: MDS recursive hierarchy for self-referencing parent-child data
Source: https://learn.microsoft.com/en-us/sql/master-data-services/recursive-hierarchies-master-data-services
Topics
Community Discussion
No community discussion yet for this question.