PrepAway - Latest Free Exam Questions & Answers

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. Domain.com contains a SQL Agent job that contains a Windows PowerShell job
step that uses the SQLCmd function to move data between servers. You need to ensure that an
operator named TestTeam is notified through an e-mail message if the job is lost while being
moved between servers.

What should you do? (Each correct answer presents part of the solution. Choose TWO.)

PrepAway - Latest Free Exam Questions & Answers

A.
You should consider adding a stored procedure to develop the TestTeam operator.

B.
You should consider enabling the Notifications and develop the TestTeam operator.

C.
You should consider creating Transactions Log and develop the TestTeam operator.

D.
You should consider leading the Notification the TestTeam operator on job failure.

E.
You should consider giving the operator as the failCsafe operator.

F.
You should consider enabling all jobs.


Leave a Reply