What should you create?

You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01.

You need to be notified immediately when fatal errors occur on Server01.

What should you create?
A . an Alert
B . a Server Audit Specification
C . an Extended Event session
D . a Resource Pool
E . a Policy
F . a SQL Profiler Trace
G . a Database Audit Specification

View Answer

Answer: A

Explanation:

References: http://www.sqlskills.com/blogs/glenn/creating-sql-server-agent-alerts-for-critical-errors/