Hotspot Question You configure a long-term retention policy for an Azure SQL database as shown in the exhibit. The first weekly backup occurred on January 4, 2020. The dates for the first 10 weekly…

Question

Exhibits

Answer Area

• The backup saved to long-term retention on January 4, 2020, will be retained for12 months
  6 weeks12 months10 years
• The backup saved to long-term retention on January 11, 2020 will be retained for10 years
  6 weeks12 months10 years

Explanation

The exhibit displays the Long-term Retention (LTR) policy configurations:

• Weekly LTR Backups: Retained for 6 weeks.
• Monthly LTR Backups: The first backup of each month is retained for 12 months.
• Yearly LTR Backups: The backup from 'Week 2' of the year is retained for 10 years.

We are given the dates for the first 10 weekly backups, starting January 4, 2020:

• January 4, 2020
• January 11, 2020
• January 18, 2020
• January 25, 2020

Based on this information:

1. The backup saved to long-term retention on January 4, 2020, will be retained for => 12 months

• January 4, 2020, is the first weekly backup listed and also the first backup that occurred in January 2020. This qualifies it as the Monthly LTR backup. As configured in the exhibit, monthly LTR backups are retained for 12 Months.

2. The backup saved to long-term retention on January 11, 2020, will be retained for => 10 years

• Considering January 4, 2020, as the first week of the year, January 11, 2020, falls in the second week (Week 2) of the year. This qualifies it as the Yearly LTR backup, as specified in the configuration ('Which weekly backup of the year would you like to retain?' is set to 'Week 2'). As configured, yearly LTR backups are retained for 10 Years.

No community discussion yet for this question.