70-465 · Question #119
70-465 Question #119: Real Exam Question with Answer & Explanation
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.
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
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
Community Discussion
No community discussion yet for this question.