Hotspot Question You have an on-premises database that you plan to migrate to Azure. You need to design the database architecture to meet the following requirements: Support scaling up and down…

Question

Exhibit

Answer Area

• Service:
  Azure SQL DatabaseAzure SQL Managed InstanceAzure Synapse AnalyticsSQL Server on Azure Virtual Machines
• Service tier:
  BasicBusiness CriticalGeneral PurposeHyperscalePremiumStandard

Explanation

This question tests knowledge of Azure database services and their capabilities, specifically which service tier and configuration supports large OLTP workloads up to 75 TB with geo-redundant backups and elastic scaling.

Approach. The correct answer is Azure SQL Database using the Business Critical or Hyperscale service tier. The Hyperscale tier specifically supports databases up to 100 TB, supports scaling up and down (both compute and storage scale independently), includes geo-redundant backup support, and is fully optimized for OLTP workloads. For the service, Azure SQL Database (PaaS) is the right choice over SQL Server on Azure VMs because it natively supports all listed requirements without manual infrastructure management. The Hyperscale tier is the only Azure SQL Database tier that can accommodate databases larger than 4 TB (up to 100 TB), making it the only valid choice for a 75 TB OLTP database with geo-redundant backups and elastic scaling.

Concept tested. Understanding Azure SQL Database service tiers - particularly the Hyperscale tier - and its capabilities including massive database size support (up to 100 TB), elastic compute/storage scaling, geo-redundant backup options, and OLTP optimization, as opposed to Azure Synapse Analytics (optimized for OLAP/data warehousing) or lower SQL Database tiers that cap at 4 TB.

Reference. https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale

No community discussion yet for this question.