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:
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. **
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
So turns out I am mistaken. https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql Hyperscale is the right answer. "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."
Why would Elastic Pools or Managed Instance not be an option for Box1?
Minimize administrative effort with a single Azure SQL Database