70-469 | You deploy a SQL Server instance named SQLProd that uses SQL…

Following is 70-469 | You deploy a SQL Server instance named SQLProd that uses SQL… from latest Microsoft practice test.

Question: 5

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

Answer: B

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)