Microsoft
70-448 · Question #112
You are creating a SQL Server 2008 Integration Services (SSIS) data flow which moves information to a SQL Server 2008 database for Company.com. You should make sure that data flow refreshes the…
The correct answer is C. You should utilize SQL Server Destination. See the full explanation below for the reasoning.
Question
You are creating a SQL Server 2008 Integration Services (SSIS) data flow which moves information to a SQL Server 2008 database for Company.com. You should make sure that data flow refreshes the existed data in the SQL Server database through utilizing data in your data flow. Which is the correct answer?
Options
- AYou should utilize Dynamic Management View (DMV)
- BYou should utilize OLE DB Destination
- CYou should utilize SQL Server Destination
- DYou should utilize Data Conversion Transformation
How the community answered
(40 responses)- A5% (2)
- B15% (6)
- C78% (31)
- D3% (1)
Community Discussion
No community discussion yet for this question.