Microsoft
70-458 · Question #122
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…
The correct answer is B. Partition the table by day and store. Partitioning the table would increase the large parallel imports.
Manage Data
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
- AReduce the value of the Maximum Insert Commit Size property.
- BPartition the table by day and store.
- CCreate a clustered index on the Transaction table.
- DRun the package in Performance mode.
How the community answered
(25 responses)- A4% (1)
- B76% (19)
- C8% (2)
- D12% (3)
Explanation
Partitioning the table would increase the large parallel imports.
Topics
#SSIS performance#table partitioning#parallel data load#OLE DB destination
Community Discussion
No community discussion yet for this question.