What should you configure?

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?
A . SQL Mail
B . An Extended Events session
C . Alerts and operators in SQL Server Agent
D . Policies under Policy-Based Management

View Answer

Answer: C

Explanation:

Operators are aliases for people or groups that can receive electronic notification when jobs have completed or alerts have been raised. The SQL Server Agent service supports the notification of administrators through operators. Operators enable notification and monitoring capabilities of SQL Server Agent.

References: https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/configure-sql-serveragent-mail-to-use-database-mail