Exam AZ-305 topic 3 question 13 discussion

It came out in the exam today at 1st Dec22, I selected B, should be correct

https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell Zone-redundant configuration is not available in SQL Managed Instance. In SQL Database this feature is only available when the Gen5 hardware is selected. To prevent Data Loss, Premium/Business Critical is required: The primary node constantly pushes changes to the secondary nodes in order and ensures that the data is persisted to at least one secondary replica before committing each transaction. This process guarantees that if the primary node crashes for any reason, there is always a fully synchronized node to fail over to.

B is correct

I would go for Azure SQL Database Premium (B) based on below Zone-redundant availability is available to databases in the Premium, Business Critical, General Purpose and Hyperscale service tiers, and not the Basic and Standard service tiers of the DTU-based purchasing model. Each service tier implements zone-redundant availability differently. This brings B and D in competition, however cost minimized B is winner based on this and you can sun cost calculator https://learn.microsoft.com/en-us/answers/questions/1057631/azure-sql-db-vs-azure-sql-managed-instance-cost

Answer is D: Zone-redundant configuration is in public preview for the General Purpose service tier and generally available for the Business Critical service tier.

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql-mi&preserve-view=true https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql-mi&preserve-view=true#supported-regions-for-business-critical-instances Supported regions for Business Critical instances Zone redundancy for Business Critical SQL Managed Instance is supported in the following regions: D is correct

Not sure why its not D, I can see that SQL MI is supporting ZRS https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql

when I see this: Costs must be minimized, the first thing is remove D. Azure SQL Managed Instance General Purpose out of my choice..

A. Azure SQL Managed Instance Business Critical There are zone redundant features on Azure SQL Managed Instance. To enable Zone redundant computing, the selected backup storage redundancy must be ZRS or GZRS. With the right configuration, you can have zone redundant on SQL Managed Instance. As of today, Zone redundancy for the General Purpose service tier is currently in preview. Thus, I would pick A as the correct answer. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql

"B" should be the answer as ZRS configuration is still in public preview stage for Azure SQL Managed instance General Purpose.

The answer is B. Azure SQL Database: Zone-redundant availability is available to databases in the General Purpose, Premium, Business Critical and Hyperscale service tiers of the vCore purchasing model, and not the Basic and Standard service tiers of the DTU-based purchasing model. https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#zone-redundant-availability Azure SQL Managed Instance: Zone-redundant configuration is in public preview for the General Purpose service tier. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql#supported-regions-for-general-purpose-instances

Its B, check this source: https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell A/D - SQL MI doesnt provide zone redundancy C - Basic doesnt provide zore redundancy

B IS CORRECT

The correct answer is B "Azure SQL Database Premium".

B is the correct answer. Zone-redundant is currently in preview for SQL Managed Instance, and is only available for the Business Critical service tier. D - SQL Managed Instance General Purpose does not support Zone-redundant as of now. So it is out of the question.

B is the correct answer.

The best option would be B. **Azure SQL Database Premium**. It provides high availability and failover capabilities, including the ability to remain available in the event of a zone outage, and supports failover between replicas without any data loss. Additionally, it provides a good balance of availability and cost, making it the most cost-effective option among the choices that still meets the requirements for high availability and failover.