Plan and implement data platform resources →mediumMultiple ChoiceObjective-mapped

DP-300 Plan and implement data platform resources Practice Question

Exhibit

Refer to the exhibit.

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

You are reviewing an ARM template snippet for creating a new Azure SQL Database. The template uses the above JSON to create a database named 'db2' in resource group 'rg1'. The source database 'db1' is in the same server 'server1' and is currently active. What will be the result of deploying this template?

⚠ Common exam trap

Many candidates assume specifying a `sourceDatabaseId` automatically triggers a copy or restore operation, but Azure SQL Database only uses that property when the `createMode` is explicitly set to `Copy`, `PointInTimeRestore`, or `Secondary`; otherwise, it is silently ignored.

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

✓

It will create a new empty database with the specified service objective.

The ARM template snippet specifies `createMode: Default` and a `requestedServiceObjectiveName`, but does not include a `sourceDatabaseId` or `restorePointInTime` property. With `createMode: Default`, Azure SQL Database creates a new empty database using the specified service objective, regardless of the presence of a `sourceDatabaseId` in the template (which is ignored when `createMode` is not set to `Copy`, `PointInTimeRestore`, or `Secondary`). Therefore, the deployment succeeds and creates a new empty database named 'db2' with the defined performance tier.

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 sourceDatabaseId is specified but not used.
Why it's wrong here
The deployment will succeed; sourceDatabaseId is simply ignored.
✗
It will create a copy of db1 in the same server.
Why it's wrong here
To create a copy, createMode should be 'Copy'.
✓
It will create a new empty database with the specified service objective.
Why this is correct
Default createMode creates an empty database.
✗
It will perform a point-in-time restore of db1 to the current time.
Why it's wrong here
Point-in-time restore requires createMode 'PointInTimeRestore' and a restorePointInTime.

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