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.
Bạn đang xem 12. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P144 PPSX