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
Bạn đang xem 6. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P82 PPSX