70-463 · Question #140
A SQL Server Integration Services (SSIS) package imports daily transactions from several files into a SQL Server table named Transaction. Each file corresponds to a different store and is imported in
The correct answer is D. Increase the value of the Row per Batch property.. Data Access Mode-This setting provides the 'fast load' option which internally uses a BULK INSERT statement for uploading data into the destination table instead of a simple INSERT statement (for each single row) as in the case for other options. - BULK INSERT parameters include:
Question
A SQL Server Integration Services (SSIS) package imports daily transactions from several files into a SQL Server table named Transaction. Each file corresponds to a different store and is imported in parallel with the other files. The data flow tasks use OLE DB destinations in fast load data access mode. The number of daily transactions per store can be very large and is growing-The Transaction table does not have any indexes. You need to minimize the package execution time. What should you do?
Options
- APartition the table by day and store.
- BCreate a clustered index on the Transaction table.
- CRun the package in Performance mode.
- DIncrease the value of the Row per Batch property.
How the community answered
(62 responses)- A3% (2)
- B15% (9)
- C6% (4)
- D76% (47)
Explanation
- Data Access Mode-This setting provides the 'fast load' option which internally uses a BULK INSERT statement for uploading data into the destination table instead of a simple INSERT statement (for each single row) as in the case for other options. - BULK INSERT parameters include: ROWS_PER_BATCH =rows_per_batch Indicates the approximate number of rows of data in the data file. By default, all the data in the data file is sent to the server as a single transaction, and the number of rows in the batch is unknown to the query optimizer. If you specify ROWS_PER_BATCH (with a value > 0) the server uses this value to optimize the bulkimport operation. The value specified for ROWS_PER_BATCH should approximately the same as the actual
Topics
Community Discussion
No community discussion yet for this question.