Monitor, configure, and optimize database resources →mediumMultiple ChoiceObjective-mapped

DP-300 Practice Question: Monitor, configure, and optimize database resources

Exhibit

Azure SQL Database Intelligent Insights log:

{
  "id": "/subscriptions/.../resourceGroups/.../providers/Microsoft.Sql/servers/.../databases/.../metrics",
  "properties": {
    "startTime": "2024-05-01T10:00:00Z",
    "endTime": "2024-05-01T11:00:00Z",
    "metrics": [
      {
        "name": "cpu_percent",
        "average": 85,
        "max": 99,
        "min": 20
      },
      {
        "name": "physical_data_read_percent",
        "average": 95,
        "max": 100,
        "min": 50
      },
      {
        "name": "log_write_percent",
        "average": 10,
        "max": 15
      }
    ],
    "observations": [
      {
        "type": "Degradation",
        "subType": "ResourceLimit",
        "details": "DTU consumption reached 100% for extended period. Consider scaling up or optimizing queries."
      }
    ]
  }
}

Current database tier: Standard S2 (50 DTU)

Refer to the exhibit. An Azure SQL Database is receiving Intelligent Insights degradation alerts. Which action should be taken first?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Implement automatic tuning recommendations

The database is hitting DTU limits (100% CPU and data IO). The alert recommends scaling up or optimizing queries. Since CPU and data IO are both high, query optimization is the better first step to avoid cost increase.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Increase the maximum storage size
Why it's wrong here
Storage is not the issue; DTU is.
✗
Change the service tier to BusinessCritical
Why it's wrong here
That would increase cost and not address the root cause.
✗
Scale up to Standard S3 (100 DTU)
Why it's wrong here
Scaling up increases cost; optimization should be tried first.
✓
Implement automatic tuning recommendations
Why this is correct
Automatic tuning can optimize queries to reduce resource usage.

Go deeper

DP-300 Practice Question: Monitor, configure, and optimize database resources

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question