PrepAway - Latest Free Exam Questions & Answers

Which two actions should you perform?

You administer a SQL Server 2008 instance that contains a very large database named
FinanceDB.

You plan to create a maintenance plan that meets the following objectives for the FinanceDB
database:
-It executes the DBCC CHECKDB statement. -It rebuilds all the indexes. -It updates all index
statistics.
You need to ensure that the maintenance plan is executed in the minimum amount of time.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Use the Reorganize Index task.

B.
Use the Update Statistics task.

C.
Use the Shrink Database task.

D.
Use the Check Database Integrity task.

E.
Use the Rebuild index task.


Leave a Reply