You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance.
You have been instructed to make sure that all ABC.com’s users, including managers, receive
daily reports via Database Mail. You are then informed that your solution should allow for
managers to receive the report as soon as possible.
Which of the following actions should you take?

A.
You should consider configuring two separate Database Mail profiles for users and managers.

B.
You should configure a Database Mail profile for users, and personally send each manager the
report.

C.
You should consider configuring two separate Database Mail accounts for users and managers.

D.
You should consider configuring a single Database Mail profile, and sending the reports as high
priority.

Explanation:

Database Mail allows you to create multiple profiles within a SQL Server instance. Optionally, you
can choose the profile that Database Mail uses when you send a message.
By using different profiles you can prioritize among the messages that are being sent.