Configure and manage automation of tasks →mediumMultiple ChoiceObjective-mapped

DP-300 Configure and manage automation of tasks Practice Question

Exhibit

{
  "type": "Microsoft.Sql/servers/databases/backupLongTermRetentionPolicies",
  "apiVersion": "2021-02-01-preview",
  "properties": {
    "weeklyRetention": "P4W",
    "monthlyRetention": "P12M",
    "yearlyRetention": "P5Y",
    "weekOfYear": 1
  }
}

Refer to the exhibit. You are reviewing an ARM template snippet for an Azure SQL Database backup long-term retention policy. The template is deployed successfully. Which statement is true about the resulting backup retention?

⚠ Common exam trap

The trap here is that candidates often misread the ISO 8601 duration values (e.g., confusing P4W with 4 months or assuming P12M means 24 months) or incorrectly associate the retention period with a different backup frequency (e.g., thinking weekly retention applies to monthly backups).

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

✓

Weekly backups are retained for 4 weeks.

The ARM template snippet defines a backup long-term retention policy for Azure SQL Database. The `weeklyRetention` property is set to `P4W`, which in ISO 8601 duration format means a period of 4 weeks. Therefore, weekly backups are retained for exactly 4 weeks. Option D correctly reflects this configuration.

Answer analysis

Option-by-option breakdown

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

✗
Monthly backups are retained for 24 months.
Why it's wrong here
MonthlyRetention is P12M, which is 12 months.
✗
Weekly backups are retained for 8 weeks.
Why it's wrong here
WeeklyRetention is P4W, not P8W.
✗
Yearly backups are retained for 1 year.
Why it's wrong here
YearlyRetention is P5Y, which is 5 years.
✓
Weekly backups are retained for 4 weeks.
Why this is correct
The weeklyRetention property is set to P4W, which is 4 weeks.

Go deeper

DP-300 Configure and manage automation of tasks Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question