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

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

Exhibit

Refer to the exhibit.
{
  "properties": {
    "databaseName": "mydb",
    "maxSizeBytes": 268435456000,
    "sku": {
      "name": "GP_Gen5_4",
      "tier": "GeneralPurpose",
      "capacity": 4
    }
  }
}

You are reviewing the configuration of an Azure SQL Database. The database is currently 250 GB in size. You are concerned about storage capacity. What is the maximum size limit for this database?

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

✓

250 GB

The database is currently 250 GB in size, which matches its maximum size limit. Therefore, the maximum size limit is 250 GB (Option C). Option A (1 TB) is incorrect because the limit is not that high. Option B (500 GB) is incorrect as it exceeds the actual limit. Option D (4 TB) is also incorrect for the same reason.

Answer analysis

Option-by-option breakdown

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

✗
1 TB
Why it's wrong here
The maxSizeBytes property shows 250 GB.
✗
500 GB
Why it's wrong here
The maxSizeBytes property shows 250 GB.
✓
250 GB
Why this is correct
The maxSizeBytes value is 250 GB.
✗
4 TB
Why it's wrong here
The maxSizeBytes property shows 250 GB.

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