Câu 17: 70-767: Implementing a SQL Data Warehouse

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?

1. A. Create an attribute group that consists of the Category and Subcategory attributes. Create a custom index for the attribute group.
2. B. Publish a business rule that will be used by the Product entity.
3. C. Create a derived hierarchy based on the Category and Subcategory attributes. Use the Category attribute as the top level for the hierarchy.
4. D. Create an attribute group that consists of the Category and Subcategory attributes. Publish a business rule for the attribute group. — đáp án hiện tại