Hotspot Question You have an Azure subscription. You are designing a Microsoft SQL Server failover cluster instance (FCI) solution. The solution must meet the following requirements: - Ensure that the

Question

Exhibit

Answer Area

• Storage type:Ultra SSD shared disk
  Azure Elastic SANPremium file sharePremium SSD shared diskStorage Spaces DirectUltra SSD shared disk
• Minimum number of subnets:3
  1234

Explanation

This question tests knowledge of Azure SQL Server Failover Cluster Instance (FCI) design, specifically the appropriate storage type and subnet configuration to meet availability, latency, and simplicity requirements across three availability zones.

Approach. The correct storage type is Azure Shared Disk (Premium SSD or Ultra Disk) - specifically Azure Shared Ultra Disk, because it provides the lowest read/write latency among Azure shared storage options and supports zone-redundant configurations across three availability zones. Ultra Disk minimizes latency while maintaining the 99.99% SLA. For subnets, the minimum required is 1 subnet - when using Azure Shared Disk with Windows Server 2025 and a multi-subnet FCI configuration, you need at least 1 subnet per availability zone, making the minimum 3 subnets total; however, with the requirement that neither a network load balancer nor DNN is needed, a multi-subnet FCI (introduced in SQL Server 2019+) allows virtual machines in different subnets to register all IP addresses in DNS, eliminating the need for an NLB or DNN. The minimum number of subnets required is therefore 3 (one per availability zone). The combination of Azure Shared Ultra Disk + 3 subnets (multi-subnet FCI) satisfies all stated requirements: 99.99% SLA via zone distribution, minimal latency via Ultra Disk, no NLB/DNN via multi-subnet FCI, and minimal administrative effort.

Concept tested. Azure SQL Server FCI design across availability zones - specifically the use of Azure Shared Ultra Disk for low-latency shared storage, and the multi-subnet FCI topology (3 subnets across 3 availability zones) to eliminate the need for a network load balancer or DNN while maintaining the 99.99% availability SLA in Windows Server 2025 environments.

Reference. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/failover-cluster-instance-azure-shared-disks-deploy?view=azuresql

No community discussion yet for this question.