Question on Replication Group for Azure SQL

[Venkat Subramani]

<div>for the below question, The answer should be Yes? </div>

If for any reason your primary database fails, you can initiate a geo-failover to any of your secondary databases. When a secondary is promoted to the primary role, all other secondaries are automatically linked to the new primary.https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview?view=azuresql#configuring-secondary-database

———

You have an Azure subscription that includes a SQL database used by your company’s global sales team. The database contains sensitive sales data and needs to be available with minimal downtime. Additionally, the database should be protected against regional outages and provide data redundancy.

You need to recommend a solution to ensure high availability and data protection for the SQL database.

The solution must maintain the ability to perform both read and write operations on the SQL database even during an Azure region outage.

Solution: Implement geo-replication for the Azure SQL Database.

Active geo-replication is configured per database, and only supports manual failover.

Since the requirement is to maintain both read and write operations during an Azure region outage, geo-replication alone does not fully meet this requirement.

Hence, the correct answer is: No.

[MattTutorialsDojo]

Hi Venkat,

The answer should be no.

The solution suggests geo-replication. Which means it creates a readable secondary database in the same region as the primary or in another region. The requirement states that in the event of an Azure region outage, you need to have both read and write operations. Now, to failover to another region, for example, you still need to do a manual failover. While failover groups do this automatically.

Hope this helps. Let me know if you have any more questions. I’ll be glad to help 🙂

Thank you.

• This reply was modified 7 months, 1 week ago by  MattTutorialsDojo.

[Venkat Subramani]

Yes, it makes sense now.

Thanks