How should you configure the Rule Editor?

DRAG DROP

You are loading a dataset into SQL Server. The dataset contains numerous duplicates for
the Artist and Song columns.
The values in the Artist column in the dataset must exactly match the values in the Artist
domain in the knowledge base. The values in the Song column in the dataset can be a close
match with the values in the Song domain.
You need to use SQL Server Data Quality Services (DQS) to define a matching policy rule to
identify duplicates.
How should you configure the Rule Editor? (To answer, drag the appropriate answers to the
answer area.)

DRAG DROP

You are loading a dataset into SQL Server. The dataset contains numerous duplicates for
the Artist and Song columns.
The values in the Artist column in the dataset must exactly match the values in the Artist
domain in the knowledge base. The values in the Song column in the dataset can be a close
match with the values in the Song domain.
You need to use SQL Server Data Quality Services (DQS) to define a matching policy rule to
identify duplicates.
How should you configure the Rule Editor? (To answer, drag the appropriate answers to the
answer area.)

Answer:



Leave a Reply 6

Your email address will not be published. Required fields are marked *


Slazenjer_m

Slazenjer_m

Artist Similar 50 Yes
Song Similar 50 No

kmr

kmr

r u sure? did you take the exam recently? what to choose in the test?

Islam

Islam

I think the above answer

Artist similar 0 yes
song similar 100 no

is the correct 1

Islam

Islam

sorry the song should be 50 not 100 due to the fact “The values in the Song column in the dataset can be a close
match with the values in the Song domain.”

Islam

Islam

“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 calculated scores assigned to each source field are summed together for a composite matching score for the two records. For each field that is not a prerequisite (with a similarity of exact or similar), set the weight between 10 and 100. The sum of the weights of the domains that are not prerequisites must be equal to 100. If the value is a prerequisite, the weight is set to 0 and cannot be changed.”

https://msdn.microsoft.com/en-us/library/hh270290.aspx

Thats why the song should be 100 and the artist should be 0
Ignore my previous comment.

Islam

Islam

For each field that is not a prerequisite (with a similarity of exact or similar), set the weight between 10 and 100. The sum of the weights of the domains that are not prerequisites must be equal to 100