PrepAway - Latest Free Exam Questions & Answers

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

PrepAway - Latest Free Exam Questions & Answers

Answer:

11 Comments on “How should you configure the Rule Editor?

        1. Islam says:

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




          0



          0
    1. Islam says:

      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




      0



      0

Leave a Reply