exam questions

Exam 70-463 All Questions

View all questions & answers for the 70-463 exam

Exam 70-463 topic 1 question 65 discussion

Actual exam question from Microsoft's 70-463
Question #: 65
Topic #: 1
[All 70-463 Questions]

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?

  • A. OLE DB Destination with Fast Load
  • B. SQL Server Destination
  • C. ADO NET Destination without Bulk Insert
  • D. ADO NET Destination with Bulk Insert
  • E. OLE DB Destination without Fast Load
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
References: http://msdn.microsoft.com/en-us/library/ms141237.aspx http://msdn.microsoft.com/en-us/library/ms139821.aspx http://msdn.microsoft.com/en-us/library/ms141095.aspx

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...