AZ-305 Question #400: Real Exam Question with Answer & Explanation

Question

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 retained for up to seven years. Which backup periods can you include in the solution?

Options

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

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.