Microsoft
70-458 · Question #37
70-458 Question #37: Real Exam Question with Answer & Explanation
Sign in or unlock 70-458 to reveal the answer and full explanation for question #37. The question stem and answer options stay visible for context.
Question
You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on ServerA. The package includes a data flow and is executed on ServerB. The destination table has its own identity column. The destination data load has the following requirements: - The identity values from the source table must be used. - Default constraints on the destination table must be ignored. - Batch size must be 100,000 rows. You need to add a destination and configure it to meet the requirements. Which destination should you use?
Options
- AADO NET Destination with Bulk Insert
- BSQL Server Destination
- COLE DB Destination with Fast Load
- DADO NET Destination without Bulk Insert
- EOLE DB Destination without Fast Load
Unlock 70-458 to see the answer
You've previewed enough free 70-458 questions. Unlock 70-458 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.