What should you do?

You are developing a Microsoft SQL Server Master Data Services (MDS) solution.

The model contains an entity named Product. The Product entity has three user-defined attributes named Category, Subcategory, and Price, respectively.

You need to ensure that combinations of values stored in the Category and Subcategory attributes are unique.

What should you do?
A . Create an attribute group that consists of the Category and Subcategory attributes. Publish a business
rule for the attribute group.
B . Publish a business rule that will be used by the Product entity.
C . Create a derived hierarchy based on the Category and Subcategory attributes. Use the Category
attribute as the top level for the hierarchy.
D . Set the value of the Attribute Type property for the Category and Subcategory attributes to Domain based.

View Answer

Answer: B

Explanation:

In Master Data Services, business rule actions are the consequence of business rule condition evaluations. If a condition is true, the action is initiated.

The Validation action "must be unique": The selected attribute must be unique independently or in combination with defined attributes.

Incorrect Answers:

A: In Master Data Services, attribute groups help organize attributes in an entity. When an entity has lots of attributes, attribute groups improve the way an entity is displayed in the Master Data Manager web application.

C: A Master Data Services derived hierarchy is derived from the domain-based attribute relationships that already exist between entities in a model.

D: In Master Data Services, a domain-based attribute is an attribute with values that are populated by members from another entity. You can think of a domain-based attribute as a constrained list; domain-based attributes prevent users from entering attribute values that are not valid. To select an attribute value, the user must pick from a list.

References: https://docs.microsoft.com/en-us/sql/master-data-services/business-rule-actions-master-data-services