nerdexam
Microsoft

70-457 · Question #137

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?

The correct answer is A. an Alert. See the full explanation below for the reasoning.

Question

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?

Options

  • Aan Alert
  • Ba Server Audit Specification
  • Can Extended Event session
  • Da Resource Pool
  • Ea Policy
  • Fa SQL Profiler Trace
  • Ga Database Audit Specification

How the community answered

(41 responses)
  • A
    73% (30)
  • D
    5% (2)
  • E
    2% (1)
  • F
    12% (5)
  • G
    7% (3)

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice