Question 440
A transactional app requires highly available relational database storage. The team confirms that engineers assume Multi-AZ eliminates the need for logical backups before bad UPDATE statements. Which choice directly addresses the documented cause?
Explanation
Correct Answer
The scenario identifies this requirement: Engineers assume Multi-AZ eliminates the need for logical backups before bad UPDATE statements. Select Keep automated backups/PITR and tested recovery procedures alongside HA as the specified technical mechanism. Replicated corruption or user mistakes still require point-in-time recovery. This response addresses the problem described rather than a different design goal.
Incorrect Answers
The option Reconnect through the RDS endpoint with appropriate DNS caching behavior addresses a separate condition: an application opens new connections to a failed RDS host using cached addresses. Managed failover uses endpoint DNS changes rather than fixed instance IPs. The actual requirement is engineers assume Multi-AZ eliminates the need for logical backups before bad UPDATE statements. Recommended corrective action: Keep automated backups/PITR and tested recovery procedures alongside HA. Replicated corruption or user mistakes still require point-in-time recovery.
Copy automated backups or snapshots to another Region using supported workflows would help if a regional outage must not destroy the last copy of critical database backups. Cross-Region copies provide geographic recovery. That is not the symptom described here: engineers assume Multi-AZ eliminates the need for logical backups before bad UPDATE statements. The matching response is Keep automated backups/PITR and tested recovery procedures alongside HA, because replicated corruption or user mistakes still require point-in-time recovery.
Enable RDS Multi-AZ deployment with supported automatic failover solves a different operational problem where the only RDS database instance fails and no standby is configured. Multi-AZ maintains a standby for availability. It does not directly address engineers assume Multi-AZ eliminates the need for logical backups before bad UPDATE statements. The case calls for Keep automated backups/PITR and tested recovery procedures alongside HA, since replicated corruption or user mistakes still require point-in-time recovery.