Microsoft
70-465 · Question #119
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…
The correct answer is B. A dynamic management view. 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.
Submitted by minji_kr· Mar 5, 2026Design and implement database solutions for SQL Server
Question
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?
Options
- AStatistics
- BA dynamic management view
- CA trigger
- DUser-defined views
How the community answered
(31 responses)- A6% (2)
- B77% (24)
- C13% (4)
- D3% (1)
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.
Topics
#Dynamic Management Views (DMV)#SQL Server monitoring#Transaction monitoring
Community Discussion
No community discussion yet for this question.