You have SQL Server on an Azure VM and need a disaster recovery solution that minimizes costs and supports RTO of 15 minutes. What should you recommend?

Master the Designing Microsoft Azure Infrastructure Solutions (AZ-305) with our comprehensive quiz. Access multiple choice questions with detailed explanations and hints. Prepare effectively for your Azure certification exam!

The recommended solution for disaster recovery in this scenario is Azure Site Recovery. This service provides a robust disaster recovery solution for Azure Virtual Machines, allowing you to replicate your SQL Server environment across different regions or within the same region.

Azure Site Recovery enables automated replication of your VM data to a secondary location, facilitating quick failover in the event of a primary site failure. To meet the specified recovery time objective (RTO) of 15 minutes, Azure Site Recovery effectively manages the replication process and supports rapid recovery, ensuring that your SQL Server operations can resume with minimal disruption.

In the context of disaster recovery solutions, it's essential to consider not only the costs but also the performance and operational continuity. Azure Site Recovery accommodates both, making it a suitable choice for organizations seeking an efficient and cost-effective solution without compromising on recovery time.

The other options, while beneficial in different scenarios, do not effectively align with the requirements outlined. Azure virtual machine availability sets help manage VM availability but do not address disaster recovery. Azure Disk Backup provides data backup but may not achieve the desired RTO of 15 minutes. An Always On availability group is a feature that enhances high availability of SQL Server databases, but it requires a more complex setup and may involve higher costs if not

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy