Home » Microsoft » 70-473 v.2 » Which data management view should you use?
You have a Microsoft Azure SQL database named DB1.
You plan to monitor the resource utilization of DB1.
You need to review the following resource utilizations:
Average compute Average I/O
Which data management view should you use?
A. sys.dm_db_resources_stats
B. sys.elastic_pool_resource_stats
C. sys.dm_exec_query_stats
D. sys.resource_stats
Correct Answer: A
Explanation/Reference:
sys.dm_db_resource_stats (Azure SQL Database) returns CPU, I/O, and memory consumption for an Azure SQL Database database. One row exists for every 15 seconds, even if there is no activity in the database.
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-resource-stats-azure-sql-database?view=azuresqldb-current