70-473 · Question #46
A customer plans to monitor the performance of a Microsoft Azure SQL database. You need to explain to the customer which metrics are used to calculate the Database Throughput Unit (DTU) percentage. Wh
The correct answer is A. Log IO percentage B. Data IO percentage C. CPU percentage. The Database Throughput Unit (DTU) percentage for an Azure SQL Database is calculated as the maximum utilization across CPU, data I/O, and transaction log I/O resources.
Question
Options
- ALog IO percentage
- BData IO percentage
- CCPU percentage
- DBlocked by firewall
- EDatabase size percentage
- FTotal database size
How the community answered
(40 responses)- A93% (37)
- E3% (1)
- F5% (2)
Why each option
The Database Throughput Unit (DTU) percentage for an Azure SQL Database is calculated as the maximum utilization across CPU, data I/O, and transaction log I/O resources.
Log IO percentage measures the utilization of transaction log writes, a key resource that contributes to the overall DTU consumption of an Azure SQL Database.
Data IO percentage quantifies the utilization of data read and write operations, which is a fundamental performance metric factored into the DTU model.
CPU percentage represents the processor utilization by the database, a primary resource component used to determine the Database Throughput Unit (DTU) consumption.
Blocked by firewall is a network connectivity status and not a performance metric used in the calculation of Database Throughput Units (DTU).
Database size percentage indicates the proportion of allocated storage that is utilized, which is a storage metric, not a dynamic throughput metric for DTU.
Total database size refers to the overall storage consumed by the database, which is a static storage metric and not a performance metric for DTU calculation.
Concept tested: Azure SQL Database DTU calculation metrics
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/purchasing-model-dtu?view=azuresql&tabs=azure-portal#dtu-model-characteristics
Topics
Community Discussion
No community discussion yet for this question.