Plan and implement data platform resources →hardMultiple ChoiceObjective-mapped

DP-300 Plan and implement data platform resources Practice Question

Exhibit

Refer to the exhibit.

```json
{
  "properties": {
    "createMode": "Recovery",
    "sourceDatabaseId": "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/servers/server1/databases/db1",
    "requestedServiceObjectiveName": "GP_Gen5_2",
    "elasticPoolId": null,
    "location": "eastus"
  }
}
```

You are reviewing an ARM template for creating a new Azure SQL Database. The template uses the above JSON to create a database named 'db2' from 'db1'. The source database 'db1' is currently in a failed state due to a storage issue. What will be the result of deploying this template?

⚠ Common exam trap

Test-takers frequently confuse a database copy with a point-in-time restore, assuming that a failed source can still be used to create a new database via recovery, but the copy operation explicitly requires an online source.

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 deployment will fail because db1 is not in a recoverable state.

The ARM template creates a new database by copying from a source database. Azure SQL Database requires the source database to be in an online and healthy state to perform a copy operation. Since db1 is in a failed state due to a storage issue, it is not accessible for copying, so the deployment will fail.

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 deployment will fail because db1 is not in a recoverable state.
Why this is correct
Recovery mode requires the source to be dropped or after geo-failover.
✗
It will create an empty database because the source is not accessible.
Why it's wrong here
Empty database creation would require createMode 'Default'.
✗
It will delete db1 and create db2 as a replacement.
Why it's wrong here
Recovery mode does not delete the source.
✗
It will create a new database by recovering db1 to its last known good state.
Why it's wrong here
Recovery mode works only for dropped databases or after geo-failover, not for failed state databases.

Go deeper

DP-300 Plan and implement data platform resources Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question