You configured an RDS instance with multi_az = true but noticed no standby instance is created. What is the most likely cause?

medium📝 Debug Q14 of 15

AWS - RDS and Relational Databases

You configured an RDS instance with multi_az = true but noticed no standby instance is created. What is the most likely cause?

AYou selected a DB instance class that does not support Multi-AZ.

BYou used the wrong database engine.

CYou set allocated storage too low.

DYou forgot to enable automatic backups.

Step-by-Step Solution

Solution:

Step 1: Check Multi-AZ requirements
Automatic backups must be enabled for Multi-AZ standby creation.
Step 2: Evaluate other options
While some instance classes may not support Multi-AZ, the most common cause for no standby is backups not enabled. Storage size and engine choice usually don't prevent standby creation.
Final Answer:
You forgot to enable automatic backups. -> Option D
Quick Check:
Automatic backups required for Multi-AZ standby [OK]

Quick Trick: Enable automatic backups to allow Multi-AZ standby creation [OK]

Common Mistakes:

Master "RDS and Relational Databases" in AWS

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More AWS Quizzes