Microsoft
70-448 · Question #280
70-448 Question #280: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #280. The question stem and answer options stay visible for context.
Question
You design a SQL Server 2008 Integration Services (SSIS) data flow that inserts data from a source query to a destination table. You need to insert only those rows that do not already exist in the destination table. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
Options
- AUse the Merge transformation.
- BUse the Lookup transformation.
- CUse the Union All transformation.
- DUse the Merge Join transformation.
- EUse the Fuzzy Lookup transformation.
- FUse the Fuzzy Grouping transformation.
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 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.