You create a Master Data Services (MDS) model that manages the master data for a Product dimension. The Product dimension has the following properties:
All the members of the Product dimension have a product type, a product subtype, and a unique product
name.
Each product has a single product type and a single product subtype.
The product type has a one-to-many relationship to the product subtype.
You need to ensure that the relationship between the product name, the product type, and the product subtype
is maintained when products are added to or updates in the database.
What should you add to the model?
A . a subscription view
B . a derived hierarchy
C . a recursive hierarchy
D . an explicit hierarchy
Answer: B
Explanation:
A Master Data Services derived hierarchy is derived from the domain-based attribute relationships that already exist between entities in a model.
You can create a derived hierarchy to highlight any of the existing domain-based attribute relationships in the model.
Incorrect Answers:
C: In Master Data Services, a recursive hierarchy is a derived hierarchy that includes a recursive relationship. A recursive relationship exists when an entity has a domain-based attribute based on the entity itself.
D: In Master Data Services, an explicit hierarchy organizes members from a single entity in any way you specify. The structure can be ragged and unlike derived hierarchies, explicit hierarchies are not based on domain-based attribute relationships.
References:
https://docs.microsoft.com/en-us/sql/master-data-services/derived-hierarchies-master-data-services