Implement a secure environment →hardMultiple ChoiceObjective-mapped

DP-300 Implement a secure environment Practice Question

Exhibit

Refer to the exhibit.
```json
{
  "type": "Microsoft.Sql/servers/databases/backupShortTermRetentionPolicies",
  "apiVersion": "2022-05-01-preview",
  "properties": {
    "retentionDays": 35,
    "diffBackupIntervalInHours": 12
  }
}
```

Refer to the exhibit. You are configuring a backup retention policy for an Azure SQL Database via ARM template. You need to ensure that point-in-time restore (PITR) is available for the maximum supported period. What is the issue with the current configuration?

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 retentionDays value exceeds the maximum supported retention period

The exhibit shows retentionDays set to 40 days, but the maximum supported retention period for point-in-time restore (PITR) in Azure SQL Database is 35 days. Therefore, the configuration is invalid because it exceeds the maximum. Option A is incorrect because the minimum retention is 7 days, so 40 days is above the minimum. Option C is incorrect: diffBackupIntervalInHours of 12 is a supported value (12 or 24). Option D is incorrect because geo-redundant storage is not required for PITR; it is a separate backup option.

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 retentionDays value is set below the minimum requirement
Why it's wrong here
35 days is the maximum, not minimum.
✓
The retentionDays value exceeds the maximum supported retention period
Why this is correct
Maximum PITR retention is 35 days; 40 days is not supported.
✗
The diffBackupIntervalInHours value is not a supported value
Why it's wrong here
12 hours is a supported value.
✗
The backup policy does not specify a geo-redundant storage option
Why it's wrong here
Geo-redundancy is not part of short-term retention policy.

Go deeper

DP-300 Implement a secure environment Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question