A BUSINESS USER HAS JUST PHONED TO SAY THAT HIS DATA WASN’T UPDATE...

12. A business user has just phoned to say that his data wasn’t updated overnight.

You check SQL Server and see that a SQL Server Agent job that runs a data

load failed last night. You want to be automatically notified via e-mail if it hap-

pens again. Which of these options will provide the most efficient, supported

solution?

A. Implement SQLMail

B. Implement Database Mail

C. Install a third-party SMTP mailer

D. Implement Service Broker

Correct Answer & Explanation: B. Database Mail is fast, efficient, reliable, and

supported. It meets the criteria in the scenario.

Incorrect Answers & Explanations: A, C, D. Answer A is incorrect because

SQLMail is less efficient and reliable than the Database Mail that supersedes it.

Answer C is incorrect because a third-party SMTP mailer would be unsup-

ported, and Database Mail is an SMTP mailer. Answer D is incorrect because

Service Broker is the messaging engine used by Database Mail. It does not

provide e-mail facilities on its own.