MemberDecember 15, 2023 at 11:01 am
This question seems to have an incorrect answer…
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:
– Zero data loss during failover
– Availability during zone outage
– Cost efficient
Which of the following options should you use?
<ul data-question_id=”12827″ data-type=”single”>
Azure SQL Managed Instance
Azure SQL Database Standard
Azure SQL Database Premium
Azure SQL Database Hyperscale
TD recommended answer is Azure SQL Managed Instance. This is not exactly correct. Azure SQL Database Premium includes zero data loss zone redundancy with auto-failover groups. Azure SQL Managed Instance “Business Critical” tier also includes the same, but with caveats and restrictions on regional availability.
Log in to reply.