PrepAway - Latest Free Exam Questions & Answers

What task types are included in a SQL Maintenance Plan?

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

PrepAway - Latest Free Exam Questions & Answers

A.
Back up databases

B.
Defrag hard disks

C.
Rebuild indexes

D.
Copy databases between servers

E.
Update database statistics


Leave a Reply