Microsoft
70-432 · Question #155
You maintain a SQL Server 2008 instance. You have an existing database maintenance plan that performs the following tasks: - Rebuilds indexes. - Checks database integrity. - Writes a report to a…
The correct answer is C. The SQL Server Agent job. See the full explanation below for the reasoning.
Question
You maintain a SQL Server 2008 instance. You have an existing database maintenance plan that performs the following tasks:
- Rebuilds indexes.
- Checks database integrity.
- Writes a report to a text file.
You need to ensure that an e-mail message is sent to the operators when the maintenance plan fails to execute successfully. What should you modify?
Options
- AThe instance.
- BThe SQL Server service.
- CThe SQL Server Agent job.
- DThe database maintenance plan.
How the community answered
(20 responses)- A20% (4)
- B5% (1)
- C70% (14)
- D5% (1)
Community Discussion
No community discussion yet for this question.