PrepAway - Latest Free Exam Questions & Answers

What should you create?

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.

You need to track all SELECT statements issued in the Contoso database only by users in a role
named Sales.
What should you create?

PrepAway - Latest Free Exam Questions & Answers

A.
An Alert

B.
A Resource Pool

C.
An Extended Event session

D.
A Server Audit Specification

E.
A SQL Profiler Trace

F.
A Database Audit Specification

G.
A Policy

H.
A Data Collector Set

2 Comments on “What should you create?


Leave a Reply