Correct Answer:
Explanation/Reference:
* Maintenance Plans
Creating SQL Server 2008 maintenance plans
You can programmatically apply many of the database maintenance operations that are discussed in this article by implementing SQL Server maintenance plans. Maintenance plans can automate and schedule essential tasks to protect your data. By using maintenance plans in SQL Server 2008 or SQL Server 2005, an administrator can schedule operations such as running database consistency checks, reorganizing indexes, or rebuilding indexes.
* To configure a SQL Server 2008 database maintenance plan
1. On the taskbar, choose Start, All Programs, Microsoft SQL Server 2008, SQL Server Management Studio.
2. In Object Explorer, connect to an instance of the SQL Server 2008 Database Engine and then expand that instance.
3. Choose Management, right-click Maintenance Plans, and then choose Maintenance Plan Wizard.
4. Choose Next until you reach the Select Plan Properties page.
And later:
Select Maintenance Tasks page
Reference: Database maintenance for SharePoint 2010 Products