ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-767 All Questions

View all questions & answers for the 70-767 exam
Go to Exam

Exam 70-767 topic 1 question 75 discussion

Actual exam question from Microsoft's 70-767
Question #: 75
Topic #: 1
[All 70-767 Questions]

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You configure a new matching policy Master Data Services (MDS) as shown in the following exhibit.

You review the Matching Results of the policy and find that the number of new values matches the new values.
You verify that the data contains multiple records that have similar address values, and you expect some of the records to match.
You need to increase the likelihood that the records will match when they have similar address values.
Solution: You increase the relative weights for Address Line 1 of the matching policy.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
Decrease the Min. matching score.
A data matching project consists of a computer-assisted process and an interactive process. The matching project applies the matching rules in the matching policy to the data source to be assessed. This process assesses the likelihood that any two rows are matches in a matching score. Only those records with a probability of a match greater than a value set by the data steward in the matching policy will be considered a match.
References:
https://docs.microsoft.com/en-us/sql/data-quality-services/data-matching
by ThomasKwakman at May 29, 2020, 4:11 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
ThomasKwakman
Highly Voted 4 years, 11 months ago
Hi, Why wouldn't it be A - Yes? Giving more weight to Address should increase the likelihood for records with the same Address to match, right? If anyone could help, it would be great! Thanks
upvoted 6 times
anon456
4 years, 9 months ago
Agreed
upvoted 1 times
...
...
DudeHere
Most Recent 4 years, 5 months ago
UPDATE: The higher the weight, the more exact the record would need to be so 100% Weight = Exact Match.Correct answer is decrease the min. matching score. Microsoft is just testing that we know the fact an admin can decrease below 80%
upvoted 1 times
Lukis92
4 years, 5 months ago
An additional important point is that we cannot increase weight for Address Line 1 without decreasing weight in another domain (currently the sum equals 100%).
upvoted 1 times
...
...
DudeHere
4 years, 5 months ago
UPDATE: The higher the weight, the MORE exact the data must be. 100% weight means it needs to be exact.
upvoted 1 times
...
DudeHere
4 years, 6 months ago
Weight: For each domain in the rule, enter a numerical weight that determines how the matching analysis for the domain will be compared to that for each other domain in the rule. The weight indicates the contribution of the field's score to the overall matching score between two records. The way I read it is: Example 153 E. Mian St 153 E. Main St If we weight this field higher in the equation, it would seem more likely to accept this as similar. https://docs.microsoft.com/en-us/sql/data-quality-services/data-matching
upvoted 1 times
...
melvin9900
4 years, 7 months ago
The minimum matching score minimum value is 80. If the matching score is below 80, the two records are not considered a match. You cannot change the range of the minimum matching score in this page. The lowest min. matching score is 80. You can, however, change the lowest minimum matching score within the Administration page
upvoted 1 times
...
CGLUE
4 years, 9 months ago
I think A is right too, you cannot set the "Min. matching score" under 80%.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago