You deploy a SQL Server instance named SQLProd that uses SQL Server 2014.
You need to recommend a solution to monitor the transactions that are 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.
Dynamic Management Views and Functions (Transact-SQL)