What should you create?

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?

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?

A.
An Alert

B.
A Resource Pool

C.
An Extended Event session

D.
A Policy

E.
A Database Audit Specification

F.
A SQL Profiler Trace

G.
A Server Audit Specification



Leave a Reply 5

Your email address will not be published. Required fields are marked *


DEREJE

DEREJE

G is the likely answer

AlexanderS

AlexanderS

No, its D.

Dan

Dan

audit will not prevent it will record but policy will prevent