-
Azure SQL Managed Instance Business Critical Question
updated 2 months, 2 weeks ago
2 Members
·
2
Posts
-
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.
-
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.
Log in to reply.