Crucial Exams

Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

Contoso hosts a business-critical Azure SQL Database in the General Purpose tier. Compliance requires all full database backups to be kept for seven years. Administrators must also be able to restore the database to any point in time within the most recent 30 days with minimal management overhead. You need to recommend the most cost-effective native Azure solution that satisfies both requirements. Which approach should you recommend?

  • Create a Recovery Services vault and use Azure Backup to protect the Azure SQL Database with a seven-year retention policy.

  • Migrate the database to an Azure SQL Managed Instance in the Business Critical tier, enable auto-failover groups, and take weekly snapshots saved to Blob storage for seven years.

  • Configure a long-term retention (LTR) policy on the Azure SQL Database to store weekly full backups for seven years and use the service's automatic backups for 30-day point-in-time restore.

  • Schedule an Azure Automation runbook to export the database as weekly BACPAC files to Azure Storage and apply lifecycle rules to retain them for seven years.

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