Administering a SQL Database Infrastructure — Question 107

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You need to examine information about logins, CPU times, and Disk I/O on a particular database in Microsoft Azure.
What should you use?

Answer options

• A. Activity Monitor
• B. Sp_who3
• C. SQL Server Management Studio (SSMS) Object Explorer
• D. SQL Server Data Collector
• E. SQL Server Data Tools (SSDT)
• F. SQL Server Configuration Manager

Correct answer: A

Explanation

The correct answer is A, Activity Monitor, which provides real-time information about SQL Server processes, including logins, CPU times, and Disk I/O. The other options, while useful for different purposes, do not focus specifically on real-time monitoring of these metrics in the same comprehensive manner as Activity Monitor.