nerdexam
Exams70-463Questions#89
Microsoft

70-463 · Question #89

70-463 Question #89: Real Exam Question with Answer & Explanation

The correct answer is B: Change the similarity threshold to 0.55.. The similarity threshold controls the minimum score required for a match to be accepted. Raising it from 0.50 to 0.55 makes the transformation stricter-only candidates with a higher similarity score are considered valid matches-which reduces incorrect (false positive) matches. Lo

Question

You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night. The SQL Azure data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest- matching string from a reference table of allowed values. The number of rows in the reference table is very large. If no acceptable match is found, the Fuzzy Lookup transformation passes a null value. The current setting for the Fuzzy Lookup similarity threshold is 0.50. Many values are incorrectly matched. You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance. What should you do?

Options

  • AChange the Exhaustive property to True,
  • BChange the similarity threshold to 0.55.
  • CChange the similarity threshold to 0.40.
  • DIncrease the maximum number of matches per lookup.

Explanation

The similarity threshold controls the minimum score required for a match to be accepted. Raising it from 0.50 to 0.55 makes the transformation stricter-only candidates with a higher similarity score are considered valid matches-which reduces incorrect (false positive) matches. Lowering it to 0.40 (C) would accept even weaker matches and increase incorrect results. Setting Exhaustive to True (A) forces the engine to compare every input row against every row in the reference table, which dramatically degrades performance on a large reference table. Increasing the maximum number of matches per lookup (D) returns more candidates but does not raise the quality bar for what is accepted as a match.

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice