You deploy a SQL Server instance named SQLProd that uses SQL Server 2014.

You need to recommend a solution to monitor the transactions that a

re running currently against SQLProd.

The solution must minimize the amount of custom code required.

What should you recommend?

A. Statistics

B. A dynamic management view

C. A trigger

D. User-defined views

Explanation:

Dynamic management

views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.

Transactions can be monitored.