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 state-

ments in parallel

B. Break the file into smaller pieces and run multiple BCP commands in par-

allel

C. 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 load