A BULK INSERT OPERATION YOU RUN WEEKLY TAKES TOO LONG TO EXECUTE. Y...

6. A BULK INSERT operation you run weekly takes too long to execute. You have been asked to optimize the performance of the operation. Which of the following options could help (select all that apply)?A. Break the file into smaller pieces and run multiple BULK INSERT statements in parallelB. Break the file into smaller pieces and run multiple BCP commands in parallelC. Ask for the source file to be sorted in the same order as the clustered index on the target table, and use the ORDER option.D. Drop any non-clustered indexes from the table before the loadCorrect Answer and Explanation: B, C, and D. Answer B is correct because breaking a file down into smaller pieces and running it in parallel allows multiple client processes to connect to SQL server and stream data in. By running the parallel loads from BCP, a portion of the processing can be distributed among the multiple client systems. Answer C is correct because having a data file pre-sorted to match the clustered index and letting BCP know via the ORDER option that the data is presorted can optimize the load of data into tables with clustered indexes. Answer D is correct because dropping non-clustered indexes on a table that has data in itIncorrect Answers and Explanations: A. Answer A is incorrect because running multiple batches in parallel with BULK INSERT increases the processing load on the server. This may even hurt the overall performance rather than help it. Parallel loads using BCP on the other hand can distribute a portion of the load over multiple client processors.