Microsoft
70-457 · Question #136
You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to write messages to the Application Log when users are added to or removed from a fixed server…
The correct answer is G. a Server Audit Specification. 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 write messages to the Application Log when users are added to or removed from a fixed server role in Server01. What should you create?
Options
- Aa Database Audit Specification
- Ba Policy
- Can Alert
- Da SQL Profiler Trace
- Ea Resource Pool
- Fan Extended Event session
- Ga Server Audit Specification
How the community answered
(40 responses)- B3% (1)
- C3% (1)
- E13% (5)
- F8% (3)
- G75% (30)
Community Discussion
No community discussion yet for this question.