Q: 2
You plan to migrate on-premises MySQL databases to Azure Database for MySQL Flexible Server.
You need to recommend a solution for the Azure Database for MySQL Flexible Server configuration.
The solution must meet the following requirements:
• The databases must be accessible if a datacenter fails.
• Costs must be minimized.
Which compute tier should you recommend?
Options
Discussion
B imo, since General Purpose supports zone redundancy for HA and costs less than Memory Optimized. Not totally sure though, these options always trip me up. Anyone else pick B here?
Option B for sure. General Purpose is the only one that supports zone-redundant HA and keeps costs reasonable compared to C.
B here. Only General Purpose and Memory Optimized support zone-redundant HA, but B costs less than C so fits the minimize cost part. Pretty sure that's what MS wants for this question, unless I'm missing something?
Is anyone picking C just because of the performance angle? I thought the "minimize cost" requirement would rule C out, since both B and C do zone-redundant HA but B is cheaper. Burstable (A) doesn’t cut it for HA. Maybe some confusion around what tiers support high availability?
Seen this type before on practice exams and official docs, pretty sure it's B.
B, not C
B tbh, Burstable can't do HA so that's a trap, and Memory Optimized is pricier than needed for cost.
I don’t think it’s C. B gives zone-redundant HA and keeps cost lower, Memory Optimized is for heavy workloads so costs more.
C vs B? Went back and forth, but official docs and practice tests point to B here.
B
Be respectful. No spam.
