What should you include in the recommendation?

You need to recommend a solution that reduces the time it takes to import the supplier data.

What should you include in the recommendation?
A . Enable instant file initialization.
B . Reorganize the indexes.
C . Disable Resource Governor.
D . Enable Auto Update Statistics.

View Answer

Answer: C

Explanation:

* The ERP application relies on an import process to load supplier data. The import process updates thousands of rows simultaneously, requires exclusive access to the database, and runs daily.