DBS-C01 Deployment and Migration Practice Question
A company is deploying a new web application and needs a fully managed relational database with automatic failover and read replicas. Which AWS service should they choose?
⚠ Common exam trap
Many exam-takers confuse DynamoDB's high availability and read replicas (DAX, global tables) with relational database requirements, or they assume that a self-managed database on EC2 can be 'fully managed' by using automation scripts, but the question explicitly requires a fully managed service.
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
✓
Amazon RDS for MySQL with Multi-AZ deployment
Amazon RDS for MySQL with Multi-AZ deployment provides a fully managed relational database service that 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, ensuring high availability. Additionally, RDS for MySQL supports read replicas for offloading read traffic, which meets the requirement for both automatic failover and read replicas.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Amazon DynamoDB
Why it's wrong here
DynamoDB is a NoSQL database, not relational.
- ✓
Amazon RDS for MySQL with Multi-AZ deployment
Why this is correct
RDS is fully managed, Multi-AZ provides automatic failover, and read replicas are supported.
- ✗
Amazon EC2 with self-managed MySQL
Why it's wrong here
EC2 is not fully managed; requires manual administration and failover setup.
- ✗
Amazon Redshift
Why it's wrong here
Redshift is a data warehouse, not designed for OLTP web applications.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DBS-C01 question from scratch — 1,663 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.