Exam AZ-305 topic 4 question 69 discussion

C is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql#service-tiers The Business Critical service tier is designed for OLTP applications with high transaction rates and low latency I/O requirements. It offers the highest resilience to failures by using several isolated replicas.

C is correct 1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical

C is the answer because Managed Instance SQL General Purpose is cheaper option but still zone redundancy is under preview. Here is Microsoft Document says "Zone redundancy for General Purpose service tier is currently in preview. "

SQL MI General Purpose is cheaper than SQL DB Business Critical failover without data loss is guaranteed DB remains available at zone outage, only performance can be degraded until the cache will fill

For high availability/no data loss related question, the answer is either Business Critical ( for vcore based) or Premium ( for DTU based)

B is wrong because Azure SQL Managed Instance General Purpose does not support Zone redundancy. Reference Migrate SQL Managed Instance to availability zone support https://learn.microsoft.com/en-us/azure/reliability/migrate-sql-managed-instance Prerequisites To migrate to availability-zone support: • Your instance must be running under Business Critical tier with the November 2022 feature wave update. • Confirm that your instance is located in a supported region. • Your instances must be running on standard-series (Gen5) hardware.

C is the answer. Storage in the general purpose tier is LRS which is not resiliant in case of zone outage https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql-db&viewFallbackFrom=azuresql-mi&tabs=azure-powershell

The best deployment option that meets all the requirements would be: C. Azure SQL Database Business Critical The Business Critical service tier is designed for applications that require low-latency responses and high transaction rates, and need the highest degree of resilience to failures. It supports multiple read-only replicas, and failover between replicas of the database occurs without any data loss. It is also designed to maintain availability in the event of a zone outage. While Azure SQL Managed Instance Business Critical also provides high availability and zero data loss, it generally costs more than Azure SQL Database Business Critical. Therefore, to minimize costs as per your requirement, Azure SQL Database Business Critical would be a better choice. Azure SQL Database Basic and Azure SQL Managed Instance General Purpose do not offer the same level of high availability and data resilience as the Business Critical options.

Option B (Azure SQL Managed Instance General Purpose) best meets the stated requirements, as it supports automatic failover between replicas and ensures availability even in the event of a zone outage, at a lower cost than Option C, and D.

Same as Question 84. https://www.examtopics.com/discussions/microsoft/view/99751-exam-az-305-topic-4-question-84-discussion

C. Azure SQL Database Business Critical

"Zone-redundant configuration is currently in preview for SQL Managed Instance, and only available for the Business Critical service tier." (https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell) So any Managed Instance option should yet not be an acceptable answer.

Hi guys, Managed Instance General Purpose zone redundant feature is not available world wide yet therefore I don't think is a "safe" answer. Therefore, it come down to C and D. Azure SQL Database Business Critical should be cheaper than Managed. I mean, managed is called managed for a reason even if you don't know the actual available specs. Upon googling, you will learn that Azure SQL Database Business Critical provide lower specs aka cheaper options than Managed.

ChatGPT says C - Azure SQL Database Business Critial

B. Azure SQL Managed Instance General Purpose

Chatgpt answer is D

Zone-redundant configuration is currently in preview for SQL Managed Instance, and only available for the Business Critical service tier. https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#general-purpose-service-tier-zone-redundant-availability