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.)
Artist Similar 50 Yes
Song Similar 50 No
r u sure? did you take the exam recently? what to choose in the test?
I think the above answer
Artist similar 0 yes
song similar 100 no
is the correct 1
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.”
“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.
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