多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now 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?()

  • A、For the SQL Server Agent, you should enable a fail-safe operator 
  • B、You should modify the database maintenance plan, making it send an e-mail to the appropriate operators 
  • C、You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. 
  • D、You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题