How should you monitor SALESDB to meet the technical requirements?

Posted by: Pdfprep Category: DP-200 Tags: , ,

How should you monitor SALESDB to meet the technical requirements?
A . Query the sys.resource_stats dynamic management view.
B . Review the Query Performance Insights for SALESD
D . Query the sys.dm_os_wait_stats dynamic management view.
E . Review the auditing information of SALESD

Answer: A

Explanation:

Scenario: Disk IO, CPU, and memory usage must be monitored for SALESDB

The sys.resource_stats returns historical data for CPU, IO, DTU consumption. There’s one row every 5 minute for a database in an Azure logical SQL Server if there’s a change in the metrics.

Leave a Reply

Your email address will not be published.