Posted by: Pdfprep
Post Date: May 15, 2021
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