Exam4Training

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

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

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version