What should you create?

You administer a Microsoft SQL Server 2012 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:

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