Crucial Exams

Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

Your company runs a business-critical workload on a single Azure SQL Database in the General Purpose tier in West Europe. Compliance policy requires that if the entire region becomes unavailable, the application must automatically fail over to another Azure region within one minute and lose at most five seconds of committed data. The solution must involve minimal administrative effort.

Which data-protection solution should you recommend?

  • Enable Azure SQL Database active geo-replication and configure the application to switch connection strings manually after a failure.

  • Configure an Azure SQL Database auto-failover group between West Europe and North Europe using the Business Critical service tier with automatic failover.

  • Enable Azure Backup with geo-redundant storage and rely on point-in-time restore to recreate the database in North Europe after an outage.

  • Migrate the database to SQL Server on Azure Virtual Machines deployed in an availability set and protect it with Azure Site Recovery.

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