🔥 40% Off Crucial Exams Memberships — This Week Only

5 hours, 15 minutes remaining!
Crucial Exams

Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

A financial-services company runs its core workload in a single Azure SQL Database in the General Purpose tier. Administrators must be able to restore the database to any point in time within the last 30 days and also recover a full backup from any week during the next 10 years. The solution must require minimal ongoing management and incur the lowest possible storage cost. Which Azure SQL capability should you recommend?

  • Use Azure Backup to protect the database by installing the Azure Backup agent and scheduling weekly backups for 10 years.

  • Create an Automation runbook that exports the database as a BACPAC file to Azure Storage every week and deletes files older than 10 years.

  • Configure active geo-replication to a secondary database in another region and keep the replica online for 10 years.

  • Enable a long-term backup retention (LTR) policy on the Azure SQL Database to store weekly full backups in Azure Blob Storage for up to 10 years.

Microsoft Azure Solutions Architect Expert AZ-305
Design data storage 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