Plan and implement data platform resources →hardMultiple Choice

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
A point-in-time restore or database copy requires the source database to be online and recoverable. Because db1 is in a failed state from a storage issue, the control-plane operation cannot read its backups, so the ARM deployment returns an error rather than creating db2.
✗
It will create an empty database because the source is not accessible.
Why it's wrong here
Database copy in Azure SQL Database requires the source to be online and accessible; a source in a failed state causes the copy operation itself to fail, not silently produce an empty database. It is tempting because a failed source sounds as though no data could be read, suggesting a blank target, but the deployment errors instead.
✗
It will delete db1 and create db2 as a replacement.
Why it's wrong here
The copyDatabase createMode duplicates db1 into db2 and never removes the source database; no ARM template operation deletes db1 here. It is tempting because replacing a failed database could seem a sensible recovery approach, but database copy is a non-destructive duplication, not a swap or replacement operation.
✗
It will create a new database by recovering db1 to its last known good state.
Why it's wrong here
Copying a database creates a transactionally consistent duplicate of the current source; it does not perform point-in-time restore to a last known good state. It is tempting because recovering a failed database sounds like the goal, but that requires a restore operation, not the copyDatabase createMode in the template.

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