SAP-C02 Design for New Solutions Practice Question
A company is deploying a web application on AWS. The application requires a relational database with read replicas for scaling read queries. The database must support automatic failover and be Multi-AZ. Which database solution meets these requirements?
⚠ Common exam trap
A common trap is selecting Amazon RDS for MySQL with Multi-AZ and Read Replicas, thinking it provides an equivalent solution; however, Aurora's architecture integrates read replicas and failover, whereas RDS requires separate configurations and manual promotion of read replicas.
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 Aurora with Multi-AZ and Aurora Replicas
Amazon Aurora with Multi-AZ and Aurora Replicas (Option B) is the correct choice because it provides a single integrated solution where Aurora Replicas serve as both read replicas for scaling read queries and automatic failover targets. In contrast, Amazon RDS for MySQL with Multi-AZ and Read Replicas (Option D) uses a separate Multi-AZ standby for failover and read replicas that are not automatically promoted; while it technically meets the individual requirements, it does not provide the combined failover and read scaling within the same tier, making Aurora the preferred solution. Option A is a NoSQL database, not relational. Option C is a caching service, not a relational database.
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 with global tables
Why it's wrong here
DynamoDB is a NoSQL database, not relational, and global tables provide multi-region replication, not read replicas.
- ✓
Amazon Aurora with Multi-AZ and Aurora Replicas
Why this is correct
Aurora provides Multi-AZ with automatic failover and up to 15 Aurora Replicas for read scaling.
- ✗
Amazon ElastiCache for Redis with replication groups
Why it's wrong here
ElastiCache is an in-memory cache, not a relational database.
- ✗
Amazon RDS for MySQL with Multi-AZ and Read Replicas
Why it's wrong here
RDS for MySQL supports Multi-AZ for failover and Read Replicas for read scaling.
Go deeper
Related to this question
About these practice questions
This SAP-C02 question is part of Courseiva's 1,660-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 SAP-C02 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 SAP-C02 exam.