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.)

Question

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.)

Accepted Answer

A. Use the Reorganize Index task. E. Use the Rebuild index task.

Answer

B. Use the Update Statistics task.

Answer

C. Use the Shrink Database task.

Answer

D. Use the Check Database Integrity task.

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…

Question

Options

How the community answered

Community Discussion