Administering a SQL Database Infrastructure — Question 80

You administer a Microsoft SQL Server 2016 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?

Answer options

• A. SQL Mail
• B. An Extended Events session
• C. Alerts and operators in SQL Server Agent
• D. Policies under Policy-Based Management

Correct answer: C

Explanation

The correct answer is C because SQL Server Agent allows you to set up alerts that can trigger email notifications when specific conditions, like transaction log growth, occur. Options A and D do not provide the necessary functionality for alerting, and B focuses on monitoring rather than sending notifications.