DBS-C01 · Question #37
A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS-specified maintenance window. What is the MOST…
The correct answer is D. Enable an Amazon RDS for MySQL Multi-AZ configuration. Explanation Enabling Multi-AZ configuration eliminates downtime during maintenance windows because AWS applies patches to the standby instance first, then performs an automatic failover to the standby, and finally patches the original primary - resulting in only a brief…
Question
A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS-specified maintenance window. What is the MOST cost-effective action that should be taken to avoid downtime?
Options
- AMigrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
- BEnable cross-Region read replicas and direct read traffic to then when Amazon RDS is down
- CEnable a read replicas and direct read traffic to it when Amazon RDS is down
- DEnable an Amazon RDS for MySQL Multi-AZ configuration
How the community answered
(27 responses)- A7% (2)
- B19% (5)
- C4% (1)
- D70% (19)
Explanation
Explanation
Enabling Multi-AZ configuration eliminates downtime during maintenance windows because AWS applies patches to the standby instance first, then performs an automatic failover to the standby, and finally patches the original primary - resulting in only a brief, automatic failover (typically 60–120 seconds) with no manual intervention required.
Why the distractors are wrong:
- Option A is incorrect because migrating to DynamoDB is a completely different database service (NoSQL vs. relational), involves significant cost and effort, and is not a practical solution to a maintenance window problem.
- Option B is incorrect because cross-Region read replicas add unnecessary cost and complexity; cross-Region replication is designed for disaster recovery, not routine maintenance windows.
- Option C is incorrect because while a read replica can handle read traffic, it cannot automatically take over write traffic during downtime, requiring manual intervention - making it less effective and not truly "avoiding" downtime.
Memory Tip: Think of Multi-AZ as your "silent understudy" - it's always in sync, ready to take over automatically without you doing anything, which is the hallmark of a cost-effective, low-effort high-availability solution. Whenever an AWS exam question mentions eliminating downtime with minimal cost and effort, Multi-AZ is almost always the answer.
Topics
Community Discussion
No community discussion yet for this question.