DBS-C01 Deployment and Migration Practice Question
A company is deploying a multi-AZ Aurora MySQL database. They need to ensure that failover happens automatically with minimal data loss. Which configuration should be used?
⚠ Common exam trap
Watch out — candidates often confuse Multi-AZ RDS for MySQL with Aurora's multi-AZ architecture, not realizing that Aurora's distributed storage and reader promotion provide superior automatic failover with minimal data loss compared to traditional RDS Multi-AZ.
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
✓
Create an Aurora cluster with one primary and two readers in different Availability Zones.
An Aurora cluster with one primary and two readers in different Availability Zones provides automatic failover with minimal data loss. Aurora uses a shared cluster volume that is replicated six ways across three AZs, ensuring that during a failover, the promoted reader has access to all committed transactions with no data loss. This configuration meets the requirement for multi-AZ high availability and automatic failover within a single 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.
- ✗
Deploy an Aurora Global Database with a primary in one region and a secondary in another region.
Why it's wrong here
Global Database is for cross-region DR, not automatic failover in the same region.
- ✗
Use a Multi-AZ RDS for MySQL deployment.
Why it's wrong here
Multi-AZ RDS for MySQL is a different engine; Aurora is the asked service.
- ✓
Create an Aurora cluster with one primary and two readers in different Availability Zones.
Why this is correct
Aurora automatically fails over to a reader with minimal data loss.
- ✗
Configure a single-AZ Aurora instance and enable cross-Region replication.
Why it's wrong here
Cross-Region replication does not provide automatic failover within the same region.
Go deeper
Related to this question
About these practice questions
This DBS-C01 question is part of Courseiva's 1,663-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
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.