What should you recommend?

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

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.