You need to design a highly available Azure SQL database that meets the following requirements:
✑ Failover between replicas of the database must occur without any data loss.
✑ The database must remain available in the event of a zone outage.
✑ Costs must be minimized.
Which deployment option should you use?
To design a highly available Azure SQL database with no data loss during failover and availability during a zone outage while minimizing costs, the correct deployment option is Azure SQL Database Premium. This option provides high availability and failover capabilities, including support for zone-redundant availability, which ensures that the database remains operational during a zone outage. Additionally, it supports failover between replicas without any data loss, which meets the specified requirements.
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.
Yes, of the selectable alternatives, it can only be premium
Today (20th nov. 2022), ZRS is in preview with SQL MI. "This feature is currently in preview for SQL Managed Instance, and only available on the Business Critical service tier. In SQL Database, when using the Business Critical tier, zone-redundant configuration is only available when the Gen5 hardware is selected." https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#premium-and-business-critical-service-tier-zone-redundant-availability
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.
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
Agree that the answer is B, but to clarify, SQL MI does in fact support zone redundancy. However, this feature is in preview for the General Purpose service tier as of Nov 2023. Source: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql#supported-regions-for-general-purpose-instances
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
Same as Question 14. https://www.examtopics.com/discussions/microsoft/view/80378-exam-az-305-topic-3-question-14-discussion
The correct answer is B "Azure SQL Database Premium".
when I see this: Costs must be minimized, the first thing is remove D. Azure SQL Managed Instance General Purpose out of my choice..
B is the correct answer.
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 CORRECT
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
"B" should be the answer as ZRS configuration is still in public preview stage for Azure SQL Managed instance General Purpose.
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
Sorry, the answer should be B and must be SQL Database Premium. Since one of the requirements is to minimize the cost and SQL Database Premium is cheaper than Azure SQL Managed Instance Business Critical.
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
perhaps of this > https://azure.microsoft.com/en-us/updates/public-preview-azure-sql-updates-for-midmarch-2024/. I would say MI General Purpose - not sure about min cost
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
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.