nerdexam
Microsoft

70-463 · Question #36

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 n

The correct answer is B. Recursive. When parent-child relationships exist within a single table, a Recursive hierarchy in MDS is the correct type to represent that self-referencing structure.

Build data quality solutions

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

  • AOrganizational
  • BRecursive
  • CNon-Mandatory Explicit
  • DMany-to-Many

How the community answered

(30 responses)
  • B
    90% (27)
  • C
    3% (1)
  • D
    7% (2)

Why each option

When parent-child relationships exist within a single table, a Recursive hierarchy in MDS is the correct type to represent that self-referencing structure.

AOrganizational

Organizational is not a standard hierarchy type in SQL Server Master Data Services; it is not a valid selection in the MDS hierarchy model.

BRecursiveCorrect

A Recursive hierarchy in SQL Server MDS is specifically designed to represent parent-child relationships stored within a single entity or table, such as a manager-to-subordinate organizational structure. The hierarchy uses a domain-based attribute that references the same entity, allowing unlimited levels of nesting. This maps directly to the single-table self-referencing source described in the scenario.

CNon-Mandatory Explicit

Non-Mandatory Explicit hierarchies require members to be explicitly assigned and are used across different entities, not for self-referencing relationships within a single table.

DMany-to-Many

Many-to-Many is not a supported hierarchy type in SQL Server Master Data Services and does not apply to manager-subordinate relationships.

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

#Master Data Services#recursive hierarchy#self-referencing relationships#organizational structure

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-463 Practice