70-463 · Question #248
70-463 Question #248: Real Exam Question with Answer & Explanation
The correct answer is B: Add an Execute SQL task that batch-updates changed rows.. If the OLE DB destination uses a fast-load data access mode, you can specify the following fast load options in the user interface, OLE DB Destination Editor, for the destination: Keep identity values from the imported data file or use unique values assigned by SQL Server. Retain
Question
Exhibit
Options
- ARemove the OLE DB command and use a Script task.
- BAdd an Execute SQL task that batch-updates changed rows.
- CSet the ValidateExternalMetadata property to False.
- DAdd an Execute SQL task that truncates and reloads the table.
- ERemove the OLE DB command and use an OLE DB destination.
Explanation
If the OLE DB destination uses a fast-load data access mode, you can specify the following fast load options in the user interface, OLE DB Destination Editor, for the destination: Keep identity values from the imported data file or use unique values assigned by SQL Server. Retain a null value during the bulk load operation. Check constraints on the target table or view during the bulk import operation. Acquire a table-level lock for the duration of the bulk load operation. Specify the number of rows in the batch and the commit size. destination? view=sql-server-2017#fast-load-options
Community Discussion
No community discussion yet for this question.