SAP-C02 Design for New Solutions Practice Question
A company is designing a global application that requires low-latency read access to a database from multiple AWS regions. The database stores user profile data that is updated infrequently. The solution must ensure eventual consistency and minimize write conflicts. Which combination of AWS services should be used?
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 DynamoDB global tables
DynamoDB global tables provide multi-region replication with eventual consistency and automatic conflict resolution. Option A is wrong because RDS Multi-AZ does not replicate across regions. Option C is wrong because Aurora Global Database provides strong consistency, not eventual. Option D is wrong because ElastiCache is a cache, not a primary data store.
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 RDS Multi-AZ with read replicas in each region
Why it's wrong here
RDS Multi-AZ is for high availability within a region, and cross-region read replicas do not provide active writes in multiple regions.
- ✓
Amazon DynamoDB global tables
Why this is correct
DynamoDB global tables replicate data across regions with eventual consistency and automatic conflict resolution.
- ✗
Amazon Aurora Global Database
Why it's wrong here
(Amazon Aurora Global Database) is wrong because it provides strong consistency, not eventual consistency, and is designed for low-latency reads but also supports writes in secondary regions, which can lead to conflicts.
- ✗
Amazon ElastiCache for Redis with global datastore
Why it's wrong here
(Amazon ElastiCache for Redis with global datastore) is wrong because ElastiCache is a caching layer, not a primary data store, and is not suitable for storing user profile data that needs to be persisted.
Go deeper
Related to this question
About these practice questions
One of 1,660 original SAP-C02 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
1 more way this is tested on SAP-C02
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 is designing a new multi-region application that requires a global database with low-latency reads and writes. The application must be able to survive a regional outage. Which database solution should they choose?
hard- A.Amazon RDS Multi-AZ
- B.Amazon ElastiCache for Redis global datastore
- ✓ C.Amazon DynamoDB global tables
- D.Amazon Aurora Global Database
Why C: Amazon DynamoDB global tables provide a fully managed, multi-region, multi-primary database that delivers low-latency reads and writes globally. The service replicates data across multiple AWS Regions automatically, allowing writes to be performed in any region with conflict resolution. In the event of a regional outage, traffic can be directed to another region, ensuring high availability. In contrast, Amazon Aurora Global Database has a single primary region for writes, so writes are not low-latency across regions.
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.