Ends in

$2 OFF ALL AWS, Azure, Google Cloud & Kubernetes Practice Exams!

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

Home Forums Azure AZ-305 Designing Microsoft Azure Infrastructure Solutions Azure SQL Managed Instance Business Critical Question


  • Azure SQL Managed Instance Business Critical Question

  • Venkat Subramani

    February 9, 2024 at 3:44 am

    While the answer is correct, the explanation omitted the given option of Azure SQL Database Premium, but gives explanation for Standard. Even Premium is incorrect, because the user wanted manual backups.

    30. QUESTION

    Your organization is in the process of provisioning a new database in the Azure environment.

    You have been assigned to design a highly available Azure SQL database. The solution should meet the following requirements:

    <ul data-indent-level=”1″>

  • Zero data loss during failover

  • Availability during zone outage

  • Allows for taking and restoring manual backups.

  • Which of the following options should you use?

    <ul data-question_id=”12827″ data-type=”single”>

  • Hence, the correct answer is: Azure SQL Managed Instance Business Critical

    Azure SQL Database Standard is incorrect because it does not provide automatic failover with zero data loss, which means there may be potential data loss during failover.

    Azure SQL Database Basic is incorrect because it does not inherently provide zone redundancy, so in the event of a zone outage, there may be downtime and unavailability of the database until the issue is resolved or failover is initiated.

    Azure SQL Database Hyperscale is incorrect. While it does guarantee zone redundancy and high availability, Azure SQL Database, in general, does not support taking manual backups. You may only restore from backups that the system has automatically taken.

  • MattTutorialsDojo

    February 9, 2024 at 7:16 pm

    Hi Venkat,

    Thank you for bringing this to our attention. We will update the explanation to reflect the correct given option.

    Please let me know if you have any further questions 🙂

    Thank you.

  • Viewing 1 - 2 of 2 replies

    Log in to reply.

    Original Post
    0 of 0 posts June 2018