DBS-C01 Deployment and Migration Practice Question
A company is deploying a new web application on AWS. The application uses Amazon RDS for MySQL as its database. The database must be highly available and automatically failover in the event of an AZ outage. The company also needs to offload read traffic from the primary database to improve performance. The application read-to-write ratio is 80:20. The database workload is variable, with occasional spikes. The company wants a cost-effective solution that scales read capacity automatically. The operations team has limited experience with AWS. Which solution should the company implement?
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
✓
Deploy an Amazon Aurora MySQL cluster with Multi-AZ and enable Aurora Auto Scaling for read replicas
This solution is correct because Amazon Aurora is MySQL-compatible, provides high availability and automatic failover through its Multi-AZ deployment, and includes Aurora Auto Scaling which automatically adjusts the number of read replicas based on workload, scaling read capacity automatically. This is cost-effective as you pay only for the replicas you use and it requires minimal management, making it ideal for teams with limited AWS experience. Option A is incorrect because read replicas do not auto-scale automatically; Application Auto Scaling for replicas requires custom setup. Option B is incorrect because scaling instance size does not offload read traffic or provide read scaling. Option D is incorrect because it lacks automatic failover and requires manual intervention.
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 RDS for MySQL instance with Multi-AZ and one or more read replicas, and use Application Auto Scaling to add replicas based on CPU utilization
Why it's wrong here
Application Auto Scaling for RDS read replicas is possible but complex; requires custom CloudWatch metrics.
- ✗
Deploy an RDS for MySQL instance with Multi-AZ and enable automatic scaling of the instance size
Why it's wrong here
Instance size scaling does not offload read traffic and may cause downtime.
- ✓
Deploy an Amazon Aurora MySQL cluster with Multi-AZ and enable Aurora Auto Scaling for read replicas
Why this is correct
Aurora provides automatic failover and auto-scaling of read replicas, and is MySQL-compatible, making it a cost-effective and simpler solution.
- ✗
Deploy an RDS for MySQL instance with multiple read replicas and use a custom script to promote a read replica in case of failure
Why it's wrong here
No automatic failover; requires custom scripting.
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.