Microsoft
70-448 · Question #314
70-448 Question #314: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #314. The question stem and answer options stay visible for context.
Question
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. You work as the technical support. According to the requirement of the company CIO, you design a SQL Server 2008 Integration Services (SSIS) data flow. The data flow inserts data from a source query to a destination table. But now you must make sure that only those rows that do not already exist in the destination table are inserted. So what should you do to accomplish this task? (choose more than one)
Options
- AIn order to accomplish this task, you can use the Fuzzy Lookup transformation
- BIn order to accomplish this task, you can use the Fuzzy Grouping transformation
- CIn order to accomplish this task, you can use the Merge transformation
- DIn order to accomplish this task, you can use the Lookup transformation
- EIn order to accomplish this task, you can use the Union All transformation
- FIn order to accomplish this task, you can use the Merge Join 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.