Crucial Exams

Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

Contoso runs an Azure SQL Managed Instance in the business-critical tier. Compliance requires the company to be able to restore the database to any point in time within the last seven days and to keep one full backup taken on the first day of every month for five years. The solution must minimize cost and administrative effort. Which approach should you recommend?

  • Enable Azure Site Recovery to replicate the managed instance to a secondary region and rely on recovery points for both short-term and long-term restores.

  • Create an Azure Backup Recovery Services vault and apply a SQL Server in Azure VM backup policy to protect the managed instance with daily and monthly backups retained for five years.

  • Develop an Azure Automation runbook that exports a BACPAC file of the database to Azure Storage each month for five-year retention and disable the service's automated backups.

  • Use the built-in automated backups for Azure SQL Managed Instance, set point-in-time retention to seven days, and configure a long-term backup retention policy that stores monthly full backups in Azure Blob storage for 60 months.

Microsoft Azure Solutions Architect Expert AZ-305
Design business continuity solutions
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot