Microsoft
70-448 · Question #169
70-448 Question #169: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #169. 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. Now you get an order from your company CIO, you're asked to develop a SQL Server 2008 Integration Services (SSIS) data flow. The data flow loads data to a SQL Server 2008 database. Using data from the rows in your data flow, you must make sure that the existing records in the SQL Server database is updated by the data flow. Of the following data flow components, which one should be used?
Options
- ASQL Server Destination should be used
- BOLE DB Destination should be used
- COLE DB Command Transformation should be used
- DData Conversion Transformation should be used.
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.