Question 1

What is the primary purpose of RDS Multi-AZ deployments?

Accepted Answer

Multi-AZ provides high availability and automatic failover to a standby replica in a different Availability Zone. The standby is synchronously replicated and not used for read traffic.

Question 2

Which RDS feature allows you to offload read traffic from the primary database instance?

Accepted Answer

Read Replicas allow you to create one or more replicas of a source DB instance for read-heavy workloads. They use asynchronous replication and can be promoted to standalone instances.

Question 3

What type of replication does RDS Multi-AZ use, and how does it differ from Read Replicas?

Accepted Answer

Multi-AZ uses synchronous replication, ensuring zero data loss during failover. Read Replicas use asynchronous replication, which may result in slight replication lag.

Question 4

How many Read Replicas can you create for a standard RDS MySQL or PostgreSQL instance?

Accepted Answer

You can create up to 5 Read Replicas for a standard RDS MySQL or PostgreSQL instance. Read Replicas can also be created in different AWS regions.

Question 5

What happens to the RDS database endpoint during a Multi-AZ failover?

Accepted Answer

The DNS endpoint remains the same but automatically resolves to the standby instance, which is promoted to primary. Applications reconnect using the same connection string with no manual intervention.

AWS RDS & Databases – Solutions Architect Associate

Also Included in the Study Bundle

Practice Tests

Study Guides

Match Game

Try These Cards

Want to keep studying?

Related Study Decks

AWS High Availability – Solutions Architect Associate

AWS IAM & Security – Solutions Architect Associate

AWS S3 & Storage – Solutions Architect Associate

AWS Serverless & Lambda – Solutions Architect Associate

AWS Solutions Architect Associate — Complete Bundle

AWS VPC & Networking – Solutions Architect Associate

Unlock the Full AWS Solutions Architect Associate Study Bundle