Administering a SQL Database Infrastructure — Question 169

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?

Answer options

• A. Statistics
• B. A dynamic management view
• C. A trigger
• D. User-defined views

Correct answer: B

Explanation

The best choice is B, a dynamic management view, as it provides real-time insights into the current transactions with minimal coding required. Options A (Statistics), C (A trigger), and D (User-defined views) do not offer the same level of straightforward monitoring for active transactions and would require additional implementation efforts.