Microsoft Exam Questions

What should you create?

You administer a Microsoft SQL Server 2012 databasenamed Contoso on a server named Server01.
You need to be notified immediatelywhen 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