What task types are included in a SQL Maintenance Plan?

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance.
You plan to automate maintenance tasks.
What task types are included in a SQL Maintenance Plan? (To answer, drag the component
to the correct task or tasks in the answer area. The component may be used once or more
than once. Each task may be used once or not at all. Additionally, you may need to drag the
split bar between panes or scroll to view content.)

Answer:

Explanation:
Note:
The Maintenance Plan Wizard creates a maintenance plan that Microsoft SQL Server Agent
can run on a regular basis. This allows you to perform various database administration
tasks, including backups, database integrity checks, or database statistics updates, at
specified intervals.
Maintenance plans can be created to perform the following tasks: / Reorganize the data on
the data and index pages by rebuilding indexes with a new fill factor. Rebuilding indexes with
a new fill factor makes sure that database pages contain an equally distributed amount of

data and free space. It also enables faster growth in the future. / Compress data files by
removing empty database pages. / Update index statistics to make sure the query optimizer
has current information about the distribution of data values in the tables. This enables the
query optimizer to make better judgments about the best way to access data, because it has
more information about the data stored in the database. Although index statistics are
automatically updated by SQL Server periodically, this option can force the statistics to
update immediately. / Perform internal consistency checks of the data and data pages within
the database to make sure that a system or software problem has not damaged data. / Back
up the database and transaction log files. Database and log backups can be retained for a
specified period. This lets you create a history of backups to be used if you have to restore
the database to a time earlier than the last database backup. You can also perform
differential backups. / Run SQL Server Agent jobs. This can be used to create jobs that
perform a variety of actions and the maintenance plans to run those jobs.