Microsoft
70-459 · Question #117
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…
The correct answer is C. A maintenance plan. Maintenance plans create a workflow of the tasks required to make sure that your database is optimized, regularly backed up, and free of inconsistencies.
Administer SQL Server
Question
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.
Options
- AA trigger
- BAn alert
- CA maintenance plan
- DWindows PowerShell
- EA system policy
How the community answered
(47 responses)- A4% (2)
- B2% (1)
- C83% (39)
- D2% (1)
- E9% (4)
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.
Topics
#maintenance plan#index rebuild#scheduled backups#SQL Agent
Community Discussion
No community discussion yet for this question.