PrepAway - Latest Free Exam Questions & Answers

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.

PrepAway - Latest Free Exam Questions & Answers

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.
Maintenance Plans


Leave a Reply