Microsoft
70-463 · Question #240
70-463 Question #240: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #240. The question stem and answer options stay visible for context.
Extract and transform data
Question
You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation. The reference data to be used in the transformation changes with every package execution. Common language runtime (CLR) integration cannot be enabled on the SQL Server database where the reference table is located. You need to configure the Fuzzy Lookup transformation in the most efficient manner. What should you do?
Options
- AExecute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure.
- BSelect the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor.
- CExecute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure.
- DSelect the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor.
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Fuzzy Lookup#index generation#CLR integration#transformation configuration