Microsoft
70-432 · Question #81
You are the administrator of a SQL Server 2008 instance with a database named DB1. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity…
The correct answer is D. You should modify the SQL Server Agent job. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named DB1. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. The company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?
Options
- AFor the SQL Server Agent, you should enable a fail-safe operator
- BYou should modify the database maintenance plan, making it send an e-mail to the appropriate
- CYou should modify the database maintenance plan, making it include a Notify Operator task that e-
- DYou should modify the SQL Server Agent job.
How the community answered
(56 responses)- A16% (9)
- B7% (4)
- C4% (2)
- D73% (41)
Community Discussion
No community discussion yet for this question.