You have Microsoft Azure SQL database named DB1. You plan to monitor the resource utilization of DB1. You need to review the following resource utilization: Average compute Average I/O Which data…

The `sys.dm_db_resource_stats` view provides near real-time resource utilization statistics for an individual Azure SQL Database, including metrics like CPU, data I/O, log I/O, and memory usage within 15-second intervals. This makes it ideal for reviewing average compute and I/O consumption for a single database.

The `sys.elastic_pool_resource_stats` view provides resource utilization for elastic pools, not for individual databases outside an elastic pool.

The `sys.dm_exec_query_stats` view provides performance statistics for cached query plans, which is not suitable for monitoring overall database compute and I/O utilization.

The `sys.resource_stats` view provides historical resource utilization data for all databases on a logical server, aggregated every five minutes, and is not designed for near real-time, specific database-level average compute and I/O as directly as `sys.dm_db_resource_stats`.