Microsoft
70-450 · Question #50
You administer a SQL Server 2008 instance. You configure a single Database Mail profile that is used to send reports to all the employees of your organization. The sp_send_dbmail stored procedure is…
The correct answer is B. Create a separate Database Mail profile for the reports. See the full explanation below for the reasoning.
Question
You administer a SQL Server 2008 instance. You configure a single Database Mail profile that is used to send reports to all the employees of your organization. The sp_send_dbmail stored procedure is used to send a large volume of reports during business hours. The reports to the manager take a long time to be delivered. You need to ensure that the reports to the manager are sent as quickly as possible. What should you do?
Options
- AModify the SMTP relay settings.
- BCreate a separate Database Mail profile for the reports.
- CConfigure the security settings of the Database Mail system.
- DModify the parameters of the email that contains the reports.
How the community answered
(38 responses)- A3% (1)
- B79% (30)
- C13% (5)
- D5% (2)
Community Discussion
No community discussion yet for this question.