You have an Azure subscription that contains an Azure SQL database named DB1. You need to recommend a long-term retention (LTR) backup solution for DB1. The solution must ensure that backups can be…

Question

Options

• Aweekly only
• Bmonthly only
• Cyearly only
• Dweekly and monthly only
• Emonthly and yearly only
• Fweekly, monthly, and yearly

• C
  8% (2)
• D
  4% (1)
• E
  4% (1)
• F
  83% (20)

Explanation

To enable LTR, you can define a policy using a combination of four parameters: weekly backup retention (W), monthly backup retention (M), yearly backup retention (Y), and week of the year (WeekOfYear). If you specify W, one backup every week is copied to long-term storage. If you specify M, the first backup of each month is copied to the long-term storage. If you specify Y, one backup during the week specified by WeekOfYear is copied to the long-term storage. If the specified WeekOfYear is in the past when the policy is configured, the first LTR backup is created the following year. Each backup is kept in long-term storage according to the policy parameters that are configured when the LTR backup is created. https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-retention-overview

No community discussion yet for this question.