Microsoft
70-473 · Question #39
70-473 Question #39: Real Exam Question with Answer & Explanation
The correct answer is C: dynamic management views. See the full explanation below for the reasoning.
Question
You have Microsoft SQL Server 2014 installed on a Microsoft Azure virtual machine. One of the databases on the virtual machine supports a highly active Online Transaction Processing (OLTP) application. Users report abnormally long wait times when they submit data in the application. Which two tools can you use to identify the longest running queries? Each correct answer presents a complete solution.
Options
- Athe Job Activity Monitor
- BDatabase Engine Tuning Advisor
- Cdynamic management views
- DSQL Server Extended Events
- ESQL metrics in Azure Diagnostics for the virtual machine
Community Discussion
No community discussion yet for this question.