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

.

You need to collect data for a long period of time to troubleshoot wait statistics when querying Contoso.

You also need to ensure minimum impact to the server.

What should you create?

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

You administer a Microsoft SQL Server 2016 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 s

hould you create?

A. a Database Audit Specification

B. a Policy

C. an Alert

D. a SQL Profiler Trace

E. a Resource Pool

F. an Extended Event session

G. a Server Audit Specification

The SQL Server Audit feature enables you to audit server-level

and database-level groups of events and individual events.

Audits can have the following categories of actions:

Server-level. These actions include server operations, such as management changes and logon and logoff operations.

Database-level. These acti

ons encompass data manipulation languages (DML) and data definition language (DDL) operations.

Audit-level. These actions include actions in the auditing process.

References: http://technet.microsoft.com/en-us/library/cc280663(v=sql.105).aspx

QUESTION

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

You need to be notified immediately when fatal errors occur on Server01.

What should you create?

A. an Alert

B. a Server Audit Specification

C. an Ext

ended Event session

D. a Resource Pool

E. a Policy

F. a SQL Profiler Trace

G. a Database Audit Specification

References: http://www.sqlskills.com/blogs/glenn/creating-sql-server-agent-alerts-for-critical-errors/

You

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

You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording events and playing them back on a different test server.

What should you create?

A. an Extended Event session

B. a Policy

C. a Database Audit Specification

D. an Alert

E. a Server Audit Specification

F. a SQL Profiler Trace

G. a Resource Pool

References:

http://msdn.microsoft.com/en-us/library/ms188246.aspx

You administer a Microsoft SQL Server 2016 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