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?
Configure a long-term retention (LTR) policy that retains weekly full backups for seven years in geo-redundant (RA-GRS) backup storage.
Use Azure Site Recovery to replicate the Azure SQL Database to the paired region and perform failover when required.
Enable active geo-replication to an Australia Southeast secondary database and rely on the default 35-day automated backup window.
Schedule an Azure Automation runbook that exports the database to a BACPAC file in an Australia Southeast storage account every night.
Automated Azure SQL Database backups provide point-in-time restore (PITR) for up to 35 days. On servers created since late 2020 these backups are stored in geo-redundant (RA-GRS) storage, so they are already available for cross-region restore within the PITR window. To satisfy the much longer seven-year requirement you must enable a long-term retention (LTR) policy, which copies specified full backups (weekly, monthly, or yearly) from the automated-backup stream into an Azure Recovery Services vault. When you select geo-redundant backup storage, each LTR copy is automatically replicated to the paired region (Australia Southeast), ensuring that the backups remain available even if Australia East becomes unavailable, while avoiding the extra compute costs of an online secondary or custom automation. Therefore, configuring an LTR policy that stores weekly full backups for seven years on RA-GRS storage is the most cost-effective and operationally simple solution.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is geo-redundant storage (RA-GRS) in Azure?
Open an interactive chat with Bash
What is a Long-Term Retention (LTR) policy in Azure SQL Database?
Open an interactive chat with Bash
How does Azure ensure point-in-time restore (PITR) functionality?
Open an interactive chat with Bash
Microsoft Azure Solutions Architect Expert AZ-305
Design business continuity solutions
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .