nerdexam
Microsoft

70-457 · Question #118

You administer a Microsoft SQL Server 2012 server. When transaction logs grow, SQL Server must send an email message to the database administrators. You need to configure SQL Server to send the…

The correct answer is C. Alerts and operators in SQL Server Agent. See the full explanation below for the reasoning.

Question

You administer a Microsoft SQL Server 2012 server. When transaction logs grow, SQL Server must send an email message to the database administrators. You need to configure SQL Server to send the email messages. What should you configure?

Options

  • ASQL Mail
  • BAn Extended Events session
  • CAlerts and operators in SQL Server Agent
  • DPolicies under Policy-Based Management

How the community answered

(22 responses)
  • A
    9% (2)
  • B
    5% (1)
  • C
    82% (18)
  • D
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice