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?
Suggested Answer:C🗳️
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-server-agent-mail-to-use-database-mail
Yes, really a bit unfair this question. Of course some kind of mailing system has to be configured before you may use e-mails in alerts.
SQL Mail was the precessor of Database Mail. But SQL Mail is marked as deprecated and shouldn't be used anymore:
https://docs.microsoft.com/en-us/sql/relational-databases/policy-based-management/use-database-mail-instead-of-sql-mail
That's probably why they want us to see "SQL Mail" as a wrong answer and choose "Alerts and operators".
But it would have been really nice if they would have mentioned in the question that database mail is already configured or wouldn't have any "mail" option in the possible answers.
Tricky question, it almost suggests that SQL Emails aren't installed yet. Alerts and Operators is the second step after SQL Emails have been setup.
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.70-764 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
vescafi
4 years, 5 months agoSlava_bcd81
4 years, 8 months agoSlava_bcd81
4 years, 7 months agoMSSucks
5 years, 2 months agoTheSwedishGuy
5 years, 3 months agoTheSwedishGuy
5 years, 3 months ago