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