Which task should you include in the maintenance plan?

You are the SQL administrator for your company. A SQL Server 2008 instance named SQL_Prod includes adatabase named Research.
The Research database contains many indexes. Users report that the Research database is experiencing performance issues.
Upon investigation, you discoverthat the indexes for the Research database are showing an average fragmentation of 20 percent.
You decide tocreate a maintenance plan that will run on a weekly basis to resolve this issue.
Which task should you include in the maintenance plan?

A.
Check Database Integrity Task

B.
Rebuild Index Task

C.
Reorganize Index Task

D.
Update Statistics Task

Explanation:

You should include the Reorganize Index Task task in the maintenance plan. Reorganizing defragments andcompacts the indexes. When indexes are fragmented, you can either reorganize or rebuild them. Reorganizing issuggested when average fragmentation is under 30 percent. The maintenance plan should not include the Check Database Integrity Task
. This task verifies the structuralintegrity of a database. The maintenance plan should not include the Rebuild Index Task . Rebuilding an index is suggested whenaverage fragmentation is 30 percent or more. The maintenance plan should not include the Update Statistics Task . This task updates the statistics for a tableor view.

Objective:
Performing Data Management Tasks

Sub-Objective:
Maintain indexes.

References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Development > Designing andImplementing Structured Storage (Database Engine) > Indexes > Optimizing Indexes > Reorganizing andRebuilding Indexes TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Integration Services > Development > Designing and Implementing Packages > Understanding the Components of an Integration Services Package > Control Flow Elements > Integration Services Tasks > Maintenance Tasks