You have a SQL Server instance on a server named Server1. You need to recommend a solution to perform the following tasks every week:
Rebuild the indexes by using a n
ew fill factor.
Run a custom T-SQL command.
Back up the databases.
What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.
A. A trigger
B. An alert
C. A maintenance plan
D. Windows PowerShell
E. A system
policy
Explanation:
Maintenance plans create a workflow of the tasks required to make sure that your database is optimized, regularly backed up, and free of inconsistencies.