Exam 70-764 topic 1 question 18 discussion

Actual exam question from Microsoft's 70-764

Question #: 18
Topic #: 1

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?

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

Show Suggested Answer

Suggested Answer: A 🗳️
Activity Monitor displays information about SQL Server processes and how these processes affect the current instance of SQL Server.
Activity Monitor is a tabbed document window with the following expandable and collapsible panes: Overview, Active User Tasks, Resource Waits, Data File I/O, and Recent Expensive Queries.
The Activity User Tasks Pane shows information for active user connections to the instance, including the following column:
* Login: The SQL Server login name under which the session is currently executing.
The Recent Expensive Queries Pane shows information about the most expensive queries that have been run on the instance over the last 30 seconds, including the following column:
* CPU (ms/sec): The rate of CPU use by the query
References: https://technet.microsoft.com/en-us/library/cc879320(v=sql.105).aspx

by TheSwedishGuy at Jan. 27, 2020, 11:41 a.m.

Comments

Submit Cancel

MelKr

5 years ago

According to https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/activity-monitor?view=sql-server-2016 Activity Monitor is not available for Azure SQL Databases as Azure has its own performance Dashboards. I suppose this is an old question which does not fit the current MS environment.

upvoted 2 times

KC

4 years, 9 months ago

I think it would be Azure monitor for Azure... So I think it's a close enough name and application that it could be considered the same thing.

upvoted 1 times

...

TheSwedishGuy

5 years, 4 months ago

Activity Monitor gives you a view of the processes and I/O, sort of like Task Manager in Windows.

upvoted 1 times

...