Microsoft
70-458 · Question #122
70-458 Question #122: Real Exam Question with Answer & Explanation
Sign in or unlock 70-458 to reveal the answer and full explanation for question #122. The question stem and answer options stay visible for context.
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.
Unlock 70-458 to see the answer
You've previewed enough free 70-458 questions. Unlock 70-458 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.