Microsoft
70-432 · Question #94
You are the administrator of a SQL Server 2008 instance. A user named Mary reports that she is waiting for a query to complete. You need to ascertain whether the query is blocked. Which tool should…
The correct answer is C. The Activity Monitor tool in Microsoft SQL Server Management Studio. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. A user named Mary reports that she is waiting for a query to complete. You need to ascertain whether the query is blocked. Which tool should you use?
Options
- AThe Windows System Monitor tool
- BThe Database Engine Tuning Advisor tool
- CThe Activity Monitor tool in Microsoft SQL Server Management Studio
- DThe Job Activity Monitor tool in Microsoft SQL Server Management Studio
How the community answered
(68 responses)- A4% (3)
- B15% (10)
- C74% (50)
- D7% (5)
Community Discussion
No community discussion yet for this question.