Exam 70-767 topic 1 question 77 discussion

Actual exam question from Microsoft's 70-767

Question #: 77
Topic #: 1

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 decrease the minimum matching score of the matching policy.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️
We 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 CGLUE at Aug. 4, 2020, 1:49 p.m.

Comments

Submit Cancel

DudeHere

4 years, 8 months ago

Update: Increasing the score means it has to be closer to exact match. 100% wieght = exact match. Correct answer is Decrease MIn Matching Score.

upvoted 2 times

...

DudeHere

4 years, 8 months ago

that's why if you INCREASE weight the address Line 1, leave the Min Matching score as low as it will go (80%) you will increase the likelihood that the records will match when they have similar address values.

upvoted 1 times

...

Cococo

4 years, 10 months ago

Passed the exam and had a slightly different exhibit. In the Min. matching score dropbox after the % symbol, there are arrows up and down one, here the down one is faded gray but on the exam's exhibit it was black coloured..

upvoted 4 times

...

othman_ee

4 years, 12 months ago

The 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 (if you are a DQS administrator). https://docs.microsoft.com/en-us/sql/data-quality-services/create-a-matching-policy?view=sql-server-ver15

upvoted 1 times

eceb

4 years, 12 months ago

so if I understood well, the answer is NO because you can change the lowest minimum within the administration page but below 80 two records are not considered a match, right?

upvoted 1 times

othman_ee

4 years, 11 months ago

What's the point of being able to change the min matching score under 80 on the admin page, if it won't do anything and stick to the 80% ruling. In my opnion the answer should be Yes.

upvoted 1 times

Anette

4 years, 11 months ago

yes, but because there is no any positive change in changing the minimum score under 80, the answer must be NO, since there is no value decreasing the minimum matching score. You are a little confusing othoman_ee.

upvoted 2 times

...

CGLUE

4 years, 12 months ago

The minimum value for the matching score is 80%, you cannot enter a value lower than 80%.

upvoted 1 times

eceb

4 years, 12 months ago

I've read that too, but there's a possibility to lower the 80% within the administrator page, so I'm confused with the answer. The minimum matching score is the threshold at or above which two records are considered to be a match (and the status for the records is set to "Matched"). Enter an integer value in increments of "1" or click the up or down arrow to increase or decrease the value in increments of "10". The 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 (if you are a DQS administrator). https://docs.microsoft.com/es-es/sql/data-quality-services/create-a-matching-policy?view=sql-server-ver15

upvoted 1 times

...