nerdexam
Microsoft

70-457 · Question #139

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to prevent users from disabling server audits in Server01. What should you create?

The correct answer is D. a Policy. 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 prevent users from disabling server audits in Server01. What should you create?

Options

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

How the community answered

(27 responses)
  • A
    7% (2)
  • C
    4% (1)
  • D
    70% (19)
  • E
    15% (4)
  • F
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice