Microsoft
70-463 · Question #65
70-463 Question #65: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #65. 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 Server A . 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
- AOLE DB Destination with Fast Load
- BSQL Server Destination
- CADO NET Destination without Bulk Insert
- DADO NET Destination with Bulk Insert
- EOLE DB Destination without Fast Load
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 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.