Question 268 of 1,730
Workload-Specific Database DesignmediumMultiple ChoiceObjective-mapped

Quick Answer

The answer is Amazon DynamoDB global tables, which are the correct choice for this global e-commerce design because they provide a fully managed, multi-Region, multi-active database that delivers low-latency reads and writes across AWS Regions while supporting strongly consistent reads when using the same-Region endpoint. This architecture achieves automatic failover by allowing any Region to independently handle writes, ensuring high availability without manual intervention. On the AWS Certified Database Specialty DBS-C01 exam, this question tests your understanding of when to choose DynamoDB global tables over Aurora Global Database or ElastiCache for Global Datastore—a common trap is assuming Aurora Global Database supports strong consistency across Regions, but it only offers eventual consistency for cross-Region reads. Remember that DynamoDB global tables trade cross-Region strong consistency for active-active availability, so the key memory tip is: "Same-Region strong, cross-Region eventually consistent, but always active."

DBS-C01 Workload-Specific Database Design Practice Question

This DBS-C01 practice question tests your understanding of workload-specific database design. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.

A company is designing a database for a global e-commerce platform that requires low-latency reads and writes across multiple AWS Regions. The database must support strongly consistent reads and provide automatic failover. Which AWS service should the company use?

Question 1mediummultiple choice
Full question →

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

Amazon DynamoDB global tables provide a fully managed, multi-Region, multi-active database solution that delivers low-latency reads and writes across AWS Regions. It supports strongly consistent reads when using the same-Region endpoint and offers automatic failover by allowing any Region to handle writes independently, ensuring high availability without manual intervention.

Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

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 ElastiCache for Redis global datastore

    Why it's wrong here

    ElastiCache is a caching layer, not suitable as a primary database with strong consistency.

  • Amazon S3 with cross-region replication

    Why it's wrong here

    S3 is object storage and does not support transactional queries or strong consistency automatically.

  • Amazon Aurora Global Database

    Why it's wrong here

    Aurora Global Database has a primary Region for writes and secondary Regions for reads only; writes are not multi-master.

  • Amazon DynamoDB global tables

    Why this is correct

    DynamoDB global tables provide multi-Region, multi-master replication with strong consistency and automatic failover.

    Related concept

    Read the scenario before looking for a memorised answer.

Common exam traps

Common exam trap: answer the scenario, not the keyword

The trap here is that candidates often confuse Amazon Aurora Global Database (which is active-passive) with a multi-active solution, assuming it supports automatic failover for writes across Regions, but DynamoDB global tables are the only option that provides true multi-Region write capability with automatic failover.

Detailed technical explanation

How to think about this question

DynamoDB global tables use a last-writer-wins (LWW) conflict resolution mechanism based on the timestamp of each write, ensuring that concurrent updates across Regions converge to a consistent state. Under the hood, each replica table is fully writable, and replication occurs asynchronously via DynamoDB Streams, typically within sub-second latency. A real-world scenario where this matters is a flash sale event where users from different continents simultaneously update inventory counts; DynamoDB global tables handle the conflicts automatically without data loss.

KKey Concepts to Remember

  • Read the scenario before looking for a memorised answer.
  • Find the constraint that changes the correct option.
  • Eliminate answers that are true in general but not in this case.

TExam Day Tips

  • Watch for words such as best, first, most likely and least administrative effort.
  • Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Real-world example

How this comes up in practice

A media company stores terabytes of video archives that are accessed once a year for audit purposes. Moving these objects to a cold storage tier (Azure Archive, S3 Glacier, or Google Nearline) costs a fraction of hot storage. Questions like this test whether you understand storage tiers, access frequency tradeoffs, and retrieval latency requirements.

What to study next

Got this wrong? Here's your next step.

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Related practice questions

Related DBS-C01 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

Practice this exam

Start a free DBS-C01 practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

FAQ

Questions learners often ask

What does this DBS-C01 question test?

Workload-Specific Database Design — This question tests Workload-Specific Database Design — Read the scenario before looking for a memorised answer..

What is the correct answer to this question?

The correct answer is: Amazon DynamoDB global tables — Amazon DynamoDB global tables provide a fully managed, multi-Region, multi-active database solution that delivers low-latency reads and writes across AWS Regions. It supports strongly consistent reads when using the same-Region endpoint and offers automatic failover by allowing any Region to handle writes independently, ensuring high availability without manual intervention.

What should I do if I get this DBS-C01 question wrong?

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

What is the key concept behind this question?

Read the scenario before looking for a memorised answer.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Same concept, more angles

5 more ways this is tested on DBS-C01

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 database for a global e-commerce platform that requires sub-millisecond read latencies from multiple AWS regions. The data is mostly read, with occasional writes. Which database solution meets these requirements?

medium
  • A.Amazon ElastiCache for Redis with global datastore.
  • B.Amazon DynamoDB with Global Tables.
  • C.Amazon Aurora MySQL with Aurora Global Database.
  • D.Amazon RDS for MySQL with Multi-AZ and read replicas.

Why B: Amazon DynamoDB with Global Tables is the correct choice because it provides a fully managed, multi-Region, multi-master database that replicates data across AWS Regions with sub-second latency, enabling sub-millisecond read latencies for a globally distributed, mostly-read workload. The occasional writes are handled efficiently by the multi-master design, which automatically resolves conflicts using last-writer-wins semantics, ensuring strong eventual consistency.

Variation 2. A company is designing a database for a global e-commerce platform that requires low-latency reads and writes from multiple AWS regions. The data must be strongly consistent within a region but can be eventually consistent across regions. Which TWO services should the company consider?

medium
  • A.Amazon DynamoDB Global Tables
  • B.Amazon ElastiCache for Redis Global Datastore
  • C.Amazon RDS Cross-Region Read Replicas
  • D.Amazon Redshift
  • E.Amazon Aurora Global Database

Why A: DynamoDB Global Tables provides multi-region replication with eventual consistency across regions and strong consistency within a region. Aurora Global Database also provides low-latency reads across regions and can be configured for cross-region replication. Option C (Redshift) is wrong because it is not designed for multi-region active-active workloads. Option D (ElastiCache Global Datastore) is wrong because it is for Redis and provides cross-region replication but with eventual consistency and is not a primary database. Option E (RDS Cross-Region Read Replicas) is wrong because they are read-only and do not support writes from multiple regions.

Variation 3. A company is designing a database for a global e-commerce platform that requires low-latency reads and writes from multiple AWS Regions. The database must support ACID transactions and complex queries with joins. Which TWO services should they consider? (Choose two.)

medium
  • A.Amazon DynamoDB with Global Tables
  • B.Amazon ElastiCache for Redis with global datastore
  • C.Amazon RDS for MySQL with cross-Region read replicas
  • D.Amazon Aurora with Aurora Global Database
  • E.Amazon Redshift with cross-Region snapshots

Why A: For global low-latency with ACID transactions and complex queries, Amazon Aurora (especially with Global Database) is a strong choice. DynamoDB is not relational and does not support complex joins natively. RDS Multi-AZ is single-region. ElastiCache is not a database. Redshift is for analytics. The correct answers are Aurora (which supports Global Database for multi-region) and possibly RDS with cross-Region replication, but RDS does not have native global database capability like Aurora. However, the question says 'which TWO services', and the best two are Aurora and DynamoDB? But DynamoDB does not support complex joins. Option A (DynamoDB) is often used for global scale but lacks joins. Option B (Aurora) is the best fit. Option C (RDS) can be used with cross-Region read replicas but not for writes. Option D (ElastiCache) is cache. Option E (Redshift) is for analytics. The only viable services for ACID and joins are Aurora and possibly RDS if they accept eventual consistency? But the question says 'low-latency reads and writes' and 'global', so Aurora Global Database is the best. The second could be DynamoDB if they use serverless and global tables, but the question explicitly says 'complex queries with joins', which DynamoDB does not support. Therefore, the correct pair is likely Aurora and something else? Actually, there is no other service that fully meets all requirements. Perhaps the answer is Aurora and RDS? But RDS does not support multi-region writes. The most reasonable is to select Aurora and DynamoDB for different workloads, but the stem implies a single database. Given the constraints, the best two are Aurora (for relational) and DynamoDB (for non-relational), but they are different paradigms. However, the exam may expect Aurora and DynamoDB as two services for different parts of the application. Alternatively, the correct answer might be Aurora and RDS with cross-Region replication? But RDS does not have global tables. I'll go with Aurora and DynamoDB as the two services that can be used together to meet the requirements: DynamoDB for high-speed key-value access and Aurora for complex queries. The question says 'which TWO services should they consider', implying they may use both. So I'll choose A and B.

Variation 4. A company is designing a database for a global e-commerce platform with strong consistency requirements. The database must support cross-region disaster recovery with RPO < 1 second and RTO < 1 minute. Which TWO AWS database services meet these requirements?

medium
  • A.Amazon Aurora Global Database
  • B.Amazon RDS Multi-AZ
  • C.Amazon Redshift with cross-region snapshot copy
  • D.Amazon ElastiCache for Redis with Global Datastore
  • E.Amazon DynamoDB Global Tables

Why A: Option A (Aurora Global Database) provides cross-region replication with typical RPO of 1 second and RTO of 1 minute. Option D (DynamoDB Global Tables) offers multi-region replication with eventual consistency but also supports strongly consistent reads in each region; however, for global tables, RPO is typically < 1 second and failover can be automated within seconds. Option B (RDS Multi-AZ) is single-region. Option C (Redshift) is not designed for OLTP. Option E (ElastiCache) is in-memory and not durable.

Variation 5. A startup is building a real-time leaderboard for a mobile game using Amazon DynamoDB. The leaderboard must update frequently and support global access with low latency. Which database design approach is most suitable?

easy
  • A.Use Amazon DynamoDB global tables with appropriate partition key design.
  • B.Use Amazon ElastiCache for Redis with replication across Regions.
  • C.Use Amazon Aurora Global Database with a single writer and multiple readers.
  • D.Use Amazon S3 with event notifications to update a leaderboard file.

Why A: Amazon DynamoDB global tables provide multi-Region, fully managed, multi-master replication, which is ideal for a real-time leaderboard requiring frequent updates and low-latency global access. By designing an appropriate partition key (e.g., game ID or time-based composite key), you can distribute write traffic evenly and avoid hot partitions, ensuring consistent performance under high update frequency.

Keep practising

More DBS-C01 practice questions

Last reviewed: Jun 24, 2026

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

Sign in to join the discussion.

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.