Identify considerations for relational data on Azure →hardMultiple ChoiceObjective-mapped

DP-900 ARM template Practice Question

Exhibit

Refer to the exhibit.

```json
{
  "properties": {
    "createMode": "Default",
    "location": "eastus",
    "sku": {
      "name": "GP_Gen5_2",
      "tier": "GeneralPurpose",
      "family": "Gen5",
      "capacity": 2
    }
  }
}
```

A company uses the above ARM template snippet to deploy an Azure SQL Database. The deployment fails with an error about invalid SKU. What is the most likely cause?

⚠ Common exam trap

Candidates often assume there is always a listed correct answer, but if the premise is factually incorrect, no option may be valid.

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

✓

The capacity value must be a multiple of 4

The deployment would not fail because of a capacity multiple requirement. 'GP_Gen5_2' is a valid vCore SKU for the GeneralPurpose tier with 2 vCores, and Azure SQL Database supports 2 vCores in the GeneralPurpose tier. Therefore none of the listed options is correct; the question is invalid as written.

Answer analysis

Option-by-option breakdown

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

✗
The SKU name 'GP_Gen5_2' is not valid for the 'GeneralPurpose' tier
Why it's wrong here
Incorrect because GP_Gen5_2 is a valid SKU name for GeneralPurpose Gen5 with 2 vCores.
✗
The 'tier' property should be 'Standard' instead of 'GeneralPurpose'
Why it's wrong here
Incorrect because 'GeneralPurpose' is the correct tier for a GP_Gen5_2 vCore SKU; 'Standard' is a DTU-based tier.
✗
The location 'eastus' does not support GeneralPurpose tier
Why it's wrong here
Incorrect because eastus supports GeneralPurpose vCore deployments.
✓
The capacity value must be a multiple of 4
Why this is correct
Incorrect because GeneralPurpose vCore capacity does not have to be a multiple of 4; 2 vCores is valid.

Go deeper

DP-900 ARM template Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question