Exam AZ-305 topic 4 question 89 discussion

C. Azure SQL Database Premium. Explanation: Azure SQL Database Premium tier offers the best high availability with an always-on model, with automatic failover and zero data loss in case of failure (RPO = 0). It also supports availability across multiple zones, meaning that it can remain available in the event of a zone outage. Here's why other options may not be suitable: Azure SQL Managed Instance General Purpose: While it provides high availability, it doesn't support automatic failover with zero data loss. It also lacks the zone redundant configuration. Azure SQL Database Hyperscale: While it supports high scale and rapid growth, it may not necessarily be the most cost-effective option for the scenario described. Azure SQL Managed Instance Business Critical: While it supports automatic failover with zero data loss, and has built-in zone redundancy, it is typically more expensive than the Azure SQL Database Premium.

I will finally be able to validate this question on the exam

D. Azure SQL Managed Instance General Purpose In this scenario, Azure SQL Managed Instance meets the given requirements because it offers automatic failover with zero data loss, ensuring data consistency and minimizing any potential loss during failover. Additionally, it supports zone redundancy, allowing for availability even during a zone outage by automatically failing over to replicas in other zones. This high availability is coupled with cost efficiency, making Azure SQL Managed Instance a suitable option that balances the necessary features with cost considerations. Hence, the correct answer is: D. Azure SQL Managed Instance General Purpose Azure SQL Database Premium 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.

Duplicate questions are noticeable.

Duplicate.