Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Azure Solutions Architect Expert · Microsoft
Step Sequence / Reordering Question
Add and arrange the steps in the correct execution order.
Hotspot Solution:
Only the Hyperscale service tier in Azure SQL Database supports multiple (up to 30) named replicas (which can be read-only secondaries or geo-secondaries) while also supporting auto-failover groups for automatic failover. General Purpose and Business Critical tiers do not support multiple named replicas (Business Critical supports only one high-availability secondary internally, and additional geo-replicas are separate). SQL Managed Instance supports Always On Availability Groups and multiple secondaries, but it does not have a “Hyperscale” tier and is not one of the dropdown options shown. Therefore, the correct answer is: Azure service or service tier: The Hyperscale service tier Replication mechanism: Auto-failover groups
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Only the Hyperscale service tier in Azure SQL Database supports multiple (up to 30) named replicas (which can be read-only secondaries or geo-secondaries) while also supporting auto-failover groups for automatic failover. General Purpose and Business Critical tiers do not support multiple named replicas (Business Critical supports only one high-availability secondary internally, and additional geo-replicas are separate). SQL Managed Instance supports Always On Availability Groups and multiple secondaries, but it does not have a “Hyperscale” tier and is not one of the dropdown options shown. Therefore, the correct answer is: Azure service or service tier: The Hyperscale service tier Replication mechanism: Auto-failover groups
Only the Hyperscale service tier in Azure SQL Database supports multiple (up to 30) named replicas (which can be read-only secondaries or geo-secondaries) while also supporting auto-failover groups for automatic failover.General Purpose and Business Critical tiers do not support multiple named replicas (Business Critical supports only one high-availability secondary internally, and additional geo-replicas are separate).SQL Managed Instance supports Always On Availability Groups and multiple secondaries, but it does not have a “Hyperscale” tier and is not one of the dropdown options shown.Therefore, the correct answer is:Azure service or service tier: The Hyperscale service tier Replication mechanism: Auto-failover groups
Azure SQL Database Hyperscale • Offers high scalability but does not support zone redundancy yet. • Failover might result in data loss (due to asynchronous replication). • Not the best choice for zone outage or data-loss prevention.