Implementing a SQL Data Warehouse — Question 17

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?

Answer options

• A. Create an attribute group that consists of the Category and Subcategory attributes. Create a custom index 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. Create an attribute group that consists of the Category and Subcategory attributes. Publish a business rule for the attribute group.

Correct answer: D

Explanation

The correct answer is D because publishing a business rule for the attribute group will enforce the uniqueness of the combinations of Category and Subcategory. Option A is incorrect as merely creating a custom index does not enforce uniqueness. Option B does not specifically address the combination of the two attributes, while option C focuses on hierarchy rather than enforcing unique values.