Microsoft
70-432 · Question #216
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? (Choose all that apply.)
The correct answer is B. Defrag hard disks C. Rebuild indexes E. Update database statistics. See the full explanation below for the reasoning.
Question
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? (Choose all that apply.)
Options
- ABack up databases
- BDefrag hard disks
- CRebuild indexes
- DCopy databases between servers
- EUpdate database statistics
How the community answered
(55 responses)- A7% (4)
- B78% (43)
- D15% (8)
Community Discussion
No community discussion yet for this question.