Ends in

ALL AWS Specialty Practice Exams for only $17.99 $13.99 each!

Find answers, ask questions, and connect with our
community around the world.

Home Forums Azure AZ-305 Designing Microsoft Azure Infrastructure Solutions Question on Replication Group for Azure SQL

  • Question on Replication Group for Azure SQL

  • Venkat Subramani

    February 6, 2024 at 11:07 am

    <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

    February 9, 2024 at 7:10 pm

    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.

    • Venkat Subramani

      February 10, 2024 at 12:01 am

      Yes, it makes sense now.


Viewing 1 - 2 of 2 replies

Log in to reply.

Original Post
0 of 0 posts June 2018