You have a SQL Server instance on a server named Server1. You need to recommend a solution to perform the following task
Posted: Mon Oct 17, 2022 4:50 pm
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
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