Designing Azure Infrastructure Solutions — Question 45

You plan to deploy an Azure Database for MySQL flexible server named Server1 to the East US Azure region.

You need to implement a business continuity solution for Server1. The solution must minimize downtime in the event of a failover to a paired region.

What should you do?

Answer options

• A. Create a read replica.
• B. Store the database files in Azure premium file shares.
• C. Implement Geo-redundant backup.
• D. Configure native MySQL replication.

Correct answer: C

Explanation

Implementing Geo-redundant backup ensures that backups are stored in a paired region, allowing for quick recovery and minimal downtime during a failover. Creating a read replica or configuring native MySQL replication may not provide the same level of failover support, while storing database files in Azure premium file shares does not address the need for continuity during a region failure.