You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. You are busy with the setting of the Database Mail profile. You want the Database Mail
profile to send reports to all of the users at ABC.com. You then use the sp_send_dbmail stored
procedure to send reports during office hours. You set everything up and it works fine. There are
no complaints from employees. However, after a week employees complain that they have to wait
too long for the daily reports that are sent through the Database Mail system you have set up.
How can you fix this problem to ensure the fastest delivery of these reports?
A.
You should consider create another SMTP account that will be used for the delivery reports to
Tess King.
B.
You should consider setting a new Database Mail profile that will be used for the delivery
reports to Tess King.
C.
You should consider setting a new Database Mail account that will be used for the delivery
reports to Tess King.
D.
You should consider increase the priority of the reports that are sent to Tess King.
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.