Bird
0
0

Given an RDS instance with Multi-AZ enabled, what happens if the primary AZ fails?

medium📝 service behavior Q4 of 15
AWS - RDS and Relational Databases
Given an RDS instance with Multi-AZ enabled, what happens if the primary AZ fails?
AThe database stops working until manual restart
BThe instance switches to read-only mode
CData is lost and must be restored from backup
DAutomatic failover to standby instance in another AZ occurs
Step-by-Step Solution
Solution:

  1. Step 1: Understand Multi-AZ failover behavior

    Multi-AZ deployment provides automatic failover to a standby instance in a different AZ if the primary fails.

  2. Step 2: Eliminate incorrect outcomes

    The database does not stop, data is not lost, and it does not switch to read-only mode during failover.

  3. Final Answer:

    Automatic failover to standby instance in another AZ occurs -> Option D

  4. Quick Check:

    Failover = automatic standby switch [OK]
Quick Trick: Failover is automatic to standby in Multi-AZ [OK]
Common Mistakes:
  • Thinking manual restart is needed
  • Assuming data loss occurs
  • Believing instance becomes read-only

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More AWS Quizzes
API Gateway - API deployment and stages - Quiz 6medium API Gateway - REST API creation - Quiz 3easy API Gateway - Why API Gateway matters - Quiz 6medium AWS Lambda - Lambda execution model - Quiz 14medium Auto Scaling - Predictive scaling overview - Quiz 3easy Auto Scaling - Auto Scaling with ELB integration - Quiz 3easy Auto Scaling - Scaling policies (target tracking, step, simple) - Quiz 6medium CloudWatch - Log groups and log streams - Quiz 14medium Elastic Load Balancing - Cross-zone load balancing - Quiz 9hard RDS and Relational Databases - Why managed databases matter - Quiz 15hard