nerdexam
Microsoft

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.

Monitor and manage an Azure data platform solution

Question

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. Which three metrics should you identify? Each correct answer presents part of the solution.

Options

  • ALog IO percentage
  • BData IO percentage
  • CCPU percentage
  • DBlocked by firewall
  • EDatabase size percentage
  • FTotal database size

How the community answered

(40 responses)
  • A
    93% (37)
  • E
    3% (1)
  • F
    5% (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.

ALog IO percentageCorrect

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.

BData IO percentageCorrect

Data IO percentage quantifies the utilization of data read and write operations, which is a fundamental performance metric factored into the DTU model.

CCPU percentageCorrect

CPU percentage represents the processor utilization by the database, a primary resource component used to determine the Database Throughput Unit (DTU) consumption.

DBlocked by firewall

Blocked by firewall is a network connectivity status and not a performance metric used in the calculation of Database Throughput Units (DTU).

EDatabase size percentage

Database size percentage indicates the proportion of allocated storage that is utilized, which is a storage metric, not a dynamic throughput metric for DTU.

FTotal database size

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

#Azure SQL Database#DTUs#performance metrics#monitoring

Community Discussion

No community discussion yet for this question.

Full 70-473 Practice