Microsoft Exam 70-767 Topic 7 Question 6 Discussion

Actual exam question for Microsoft's 70-767 exam

Question #: 6
Topic #: 7

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?

ACreate two custom indexes, one for each of the Category and Subcategory attributes.

BPublish a business rule that will be used by the Product entity.

CCreate a derived hierarchy based on the Category and Subcategory attributes. Use the Category attribute as the top level for the hierarchy.

DSet the value of the Attribute Type property for the Category and Subcategory attributes to Domain-based.

Show Suggested Answer

Suggested Answer: A

References:

https://docs.microsoft.com/en-us/sql/master-data-services/custom-index-master-data-services?view=sql-server-ver15

by Stephane at May 06, 2022, 05:41 AM

Limited Time Offer

25%

Off

Get Premium 70-767 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!