Exam 70-767 topic 1 question 93 discussion

Actual exam question from Microsoft's 70-767

Question #: 93
Topic #: 1

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. 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.

Show Suggested Answer

Suggested Answer: D 🗳️
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.
References:
https://docs.microsoft.com/en-us/sql/master-data-services/business-rule-actions-master-data-services

by mohroshdy at March 7, 2020, 7:13 a.m.

Comments

Submit Cancel

mohroshdy

Highly Voted 5 years, 3 months ago

The correct answer is B

upvoted 7 times

...

Slava_bcd81

Most Recent 4 years, 8 months ago

I would say A, we need index

upvoted 1 times

...

Cococo

4 years, 8 months ago

In the exam, they've replaced B with something like that, 'creating a unique attribute for the Product entity'. There was nothing about the Business Rules.

upvoted 3 times

hemach

4 years, 7 months ago

What is the correct answer?

upvoted 2 times

...

Dieter

5 years, 1 month ago

According to the other two comments. correct is B. Attribute groups are not necessary for the requirement. Business rule is enough.

upvoted 3 times

...

als2kool

5 years, 2 months ago

The answer is correct. Business rules apply to attributes

upvoted 2 times

...