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