Exam AZ-305 topic 2 question 37 discussion

As part of the requirement -> Support multiple read-only replicas. Hyperscale is the right choice. Business critical tier has only 1 additional read replica. https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-sql-database-vcore?view=azuresql

The given answers are correct. Please refer MS doc, it says that "In Premium and Business Critical service tiers, only one of the read-only replicas is accessible at any given time. Hyperscale supports multiple read-only replicas." Hence for load balancing between multiple read replica, first need is that they should be available, which makes Hyperscale suitable for this. I hope this helps. https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql

CORRECT

Why would Elastic Pools or Managed Instance not be an option for Box1?

It is hard one to figure out (Between Hyperscale and business critical) but based on this comment from the requirements * Automatically load balance read-only requests across all the read-only replicas Only Hyperscale can do this Note: for thos who made comment that "Business critical tier has only 1 additional read replica." is NOT true, see link below and as per comment ""each single database or elastic pool database in the Premium and Business Critical service tier is automatically provisioned with a primary read-write replica and one or more secondary read-only replicas. The secondary replicas are provisioned with the same compute size as the primary replica. ** https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql

First box seems correct. For the second one, the Azure SQL Database in the Business Critical or Hyperscale service tiers automatically provisions a primary read-write replica and one or more secondary read-only replicas, so theoretically both are valid, not sure which one to choose, maybe Hyperscale is overkill.