Plan and implement data platform resources →easyMultiple ChoiceObjective-mapped

DP-300 Plan and implement data platform resources Practice Question

Exhibit

Refer to the exhibit.

```json
{
  "properties": {
    "createMode": "PointInTimeRestore",
    "sourceDatabaseId": "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/servers/server1/databases/db1",
    "requestedServiceObjectiveName": "GP_Gen5_2",
    "restorePointInTime": "2025-03-15T10:00:00Z",
    "location": "eastus"
  }
}
```

You are reviewing an ARM template for creating a new Azure SQL Database. The template uses the above JSON. The source database 'db1' was created on 2025-03-01 and has a current backup retention of 7 days. The restore point is 2025-03-15T10:00:00Z. What will be the result of deploying this template?

⚠ Common exam trap

The trap is that candidates may incorrectly think the 7-day retention is counted forward from the database creation date, making them believe a restore point 14 days after creation is too old. In reality, Azure SQL Database retention is a sliding window backward from the current date, so any restore point within the last 7 days is valid regardless of when the database was created.

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 succeed and create a new database restored to the specified point in time.

The ARM template specifies a restore point of 2025-03-15T10:00:00Z. Azure SQL Database point-in-time restore (PITR) uses a sliding window of the configured backup retention period (7 days) backward from the current date. Assuming the current date is 2025-03-22, the retention window covers from 2025-03-15 to 2025-03-22. The restore point falls exactly at the start of this window, so it is valid. The deployment will succeed and create a new database restored to that exact timestamp.

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 the restore point is older than 7 days.
Why it's wrong here
The restore point is within the 7-day retention if current date is around 2025-03-20.
✗
The deployment will succeed but the restore point will be ignored and the latest backup will be used.
Why it's wrong here
The restorePointInTime is respected when createMode is PointInTimeRestore.
✗
The deployment will fail because the source database is not geo-replicated.
Why it's wrong here
Point-in-time restore does not require geo-replication.
✓
The deployment will succeed and create a new database restored to the specified point in time.
Why this is correct
The restore point is valid and within retention.

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