[Solved] Given this AWS CLI command to create an RDS instance with Multi-AZ enabled: aws rds create-db-instance --db-instance-identifier mydb --engine mysql --allocated-storage 20 --db-instance-class db.t3.... | AWS

AWS - RDS and Relational Databases

Given this AWS CLI command to create an RDS instance with Multi-AZ enabled:

aws rds create-db-instance --db-instance-identifier mydb --engine mysql --allocated-storage 20 --db-instance-class db.t3.micro --multi-az true

What will happen if the primary AZ fails?

AAWS will automatically failover to the standby instance in another AZ.

BThe database will stop working until manual recovery.

CThe database will scale up resources automatically.

DThe database will delete all data and restart.

Step-by-Step Solution

Solution:

Step 1: Understand Multi-AZ failover behavior
Multi-AZ creates a standby in another zone that AWS switches to automatically if the primary fails.
Step 2: Analyze options
AWS will automatically failover to the standby instance in another AZ. matches this automatic failover. Others describe stopping, scaling, or deleting which are incorrect.
Final Answer:
AWS will automatically failover to the standby instance in another AZ. -> Option A
Quick Check:
Multi-AZ = automatic failover [OK]

Quick Trick: Multi-AZ means automatic failover on AZ failure [OK]

Common Mistakes:

Master "RDS and Relational Databases" in AWS

9 interactive learning modes - each teaches the same concept differently

More AWS Quizzes

Given this AWS CLI command to create an RDS instance with Multi-AZ enabled: