Crucial Exams

Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

Your organization hosts a mission-critical Azure SQL Database in the Business Critical service tier. Compliance rules state that you must be able to restore the database to any point in time during the last 7 days and also keep a restorable copy of each month-end full backup for 10 years. Management wants the simplest native Azure solution that minimizes ongoing administration and storage costs. Which approach should you recommend?

  • Create an active geo-replica in another Azure region and use geo-restore and backup retention on that replica to satisfy both objectives.

  • Enable Azure SQL Database long-term retention (LTR) for monthly backups stored in Azure Blob storage and rely on the service's automatic point-in-time restore capability for the recent 7-day window.

  • Schedule an Azure Automation runbook to export a BACPAC file of the database to Azure Storage at the end of each month and keep the files for 10 years.

  • Protect the database with Azure Backup by creating a Recovery Services vault and configuring a SQL in Azure VM backup policy.

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