Implement a secure environment →mediumMultiple ChoiceObjective-mapped

DP-300 Implement a secure environment Practice Question

Exhibit

Refer to the exhibit.

```json
{
  "type": "Microsoft.Sql/servers/databases/backupShortTermRetentionPolicies",
  "apiVersion": "2023-05-01-preview",
  "name": "Default",
  "properties": {
    "retentionDays": 7,
    "diffBackupIntervalInHours": 12
  }
}
```

Refer to the exhibit. You are reviewing an ARM template for an Azure SQL Database. The template configures backup retention. What is the effect of this configuration?

⚠ Common exam trap

It's easy for candidates to confuse the PITR retention period with the frequency of backups, or assume that the retention setting controls the backup schedule (e.g., thinking full backups occur every 12 hours), when in fact it only controls how long backups are kept, not how often they are taken.

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

✓

Point-in-time restore (PITR) backups are retained for 7 days, and differential backups occur every 12 hours.

The ARM template configures the backup retention settings for Azure SQL Database. By default, Azure SQL Database automatically performs full backups every week, differential backups every 12 hours, and transaction log backups every 5–10 minutes. The configuration shown sets the point-in-time restore (PITR) retention period to 7 days, meaning you can restore the database to any point within the last 7 days. Differential backups occur every 12 hours to support efficient PITR, but the retention setting directly controls how far back you can perform a point-in-time restore.

Answer analysis

Option-by-option breakdown

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

✗
Full backups are taken every 12 hours and retained for 7 days.
Why it's wrong here
Full backups are weekly; diffBackupIntervalInHours controls differential backups.
✗
Long-term retention (LTR) is set to 7 days.
Why it's wrong here
This is short-term retention policy, not LTR.
✓
Point-in-time restore (PITR) backups are retained for 7 days, and differential backups occur every 12 hours.
Why this is correct
The properties directly set PITR retention and differential backup interval.
✗
Transaction log backups are taken every 12 hours.
Why it's wrong here
Transaction log backups are frequent (every 5-10 min), not controlled by this property.

Go deeper

DP-300 Implement a secure environment Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question