DBS-C01 Deployment and Migration Practice Question
A company is deploying a new application that uses Amazon RDS for MySQL. The database must be highly available with automatic failover. Which deployment configuration meets these requirements?
⚠ Common exam trap
Watch out — candidates often confuse Read Replicas (which are asynchronous and used for read scaling) with Multi-AZ standby replicas (which are synchronous and used for high availability), leading them to incorrectly select Option A as a valid high-availability solution.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Multi-AZ deployment with a standby replica in a different Availability Zone
A Multi-AZ deployment for Amazon RDS for MySQL automatically provisions and maintains a synchronous standby replica in a different Availability Zone. In the event of a failure, Amazon RDS automatically fails over to the standby, providing high availability without manual intervention. This configuration meets the requirement for automatic failover and high availability within a single AWS region.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Single-AZ with a Read Replica in the same region
Why it's wrong here
Read Replicas do not provide automatic failover.
- ✗
Multi-AZ deployment with synchronous replication to a cross-region replica
Why it's wrong here
Cross-region replicas are for disaster recovery, not automatic failover.
- ✓
Multi-AZ deployment with a standby replica in a different Availability Zone
Why this is correct
Multi-AZ provides automatic failover.
- ✗
Single-AZ with automated backups
Why it's wrong here
No automatic failover.
Go deeper
Related to this question
About these practice questions
One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on DBS-C01
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A company wants to deploy an Amazon RDS for MySQL database for a new application. The database must be highly available with automatic failover. Which configuration should they choose?
easy- A.Deploy a single-AZ instance with automated backups
- B.Deploy a cross-region replica
- C.Deploy a single-AZ instance with a read replica
- ✓ D.Deploy a Multi-AZ instance with a standby replica
Why D: A Multi-AZ deployment for Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone. In the event of a failure, Amazon RDS automatically fails over to the standby, providing high availability without manual intervention. This configuration meets the requirement for automatic failover and high availability.
Variation 2. A company is deploying a new web application that uses Amazon RDS for MySQL. To meet high availability requirements, the database must automatically failover to a standby in a different Availability Zone with minimal downtime. Which deployment configuration should be used?
easy- ✓ A.Multi-AZ deployment with automatic failover
- B.Single-AZ deployment with enhanced monitoring
- C.Multi-AZ cluster deployment
- D.Single-AZ deployment with a read replica
Why A: A Multi-AZ deployment for Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone. If the primary DB instance fails, Amazon RDS automatically fails over to the standby, typically within 60–120 seconds, without requiring manual intervention. This meets the high availability requirement with minimal downtime.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DBS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DBS-C01 exam.