nerdexam
Microsoft

70-432 · Question #80

You are the administrator of SQL Server 2008 instance. There is a single Database Mail profile. Reports are sent to all the company employees by using the Mail profile. During office hours, a large…

The correct answer is D. You should configure a new Database Mail profile. The new one will be used for sending the. See the full explanation below for the reasoning.

Question

You are the administrator of SQL Server 2008 instance. There is a single Database Mail profile. Reports are sent to all the company employees by using the Mail profile. During office hours, a large volume of reports are sent by the sp_send_dbmail stored procedure. Now you notice that it takes a long time for the reports to be sent to the company manager. As the technical support, you have to speed up the delivery. Which action should you perform to achieve this goal?

Options

  • AAnother SMTP account should be added to the existing Database Mail profile
  • BWhen you send the reports to the manager, you should use the @importance = high parameter.
  • CYou should change the Account Retry Attempts option of the Database Mail system properties
  • DYou should configure a new Database Mail profile. The new one will be used for sending the

How the community answered

(32 responses)
  • A
    16% (5)
  • B
    3% (1)
  • C
    6% (2)
  • D
    75% (24)

Community Discussion

No community discussion yet for this question.

Full 70-432 Practice