Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

You administer an Azure SQL Database in the General Purpose tier hosted in the Australia East region. Compliance rules require the ability to restore the database to any point in time for the next seven years, even if the Australia East region suffers a prolonged outage. Ongoing operational overhead and costs must be kept as low as possible. Which approach should you implement to meet these requirements?

  • Enable active geo-replication to an Australia Southeast secondary database and rely on the default 35-day automated backup window.

  • Configure a long-term retention (LTR) policy that retains weekly full backups for seven years in geo-redundant (RA-GRS) backup storage.

  • Schedule an Azure Automation runbook that exports the database to a BACPAC file in an Australia Southeast storage account every night.

  • Use Azure Site Recovery to replicate the Azure SQL Database to the paired region and perform failover when required.

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.

Bash, the Crucial Exams Chat Bot
AI Bot