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

Home › Forums › Azure › AZ-305 Designing Microsoft Azure Infrastructure Solutions › Clarification about SQL failover and data loss › Reply To: Clarification about SQL failover and data loss

  • Irene-TutorialsDojo

    Administrator
    June 10, 2026 at 3:37 pm

    Hi toxic,

    Thank you for flagging this; you’re correct. SQL Managed Instance General Purpose with zone redundancy does support synchronous replication and guarantees zero data loss during zone failures, as stated in the Microsoft documentation you referenced.

    The explanation has been updated. The correct reason SQL MI GP is not the best answer is cost; it provisions a full managed instance with features unnecessary for a single transactional database, making it more expensive than Azure SQL Database Premium, which offers equivalent zone-redundant HA. The answer choice (Premium) remains the same.

    Thanks for helping us keep the content accurate!

    Best,

    Irene @ Tutorials Dojo

Skip to content