Courseiva
Workload-Specific Database DesignmediumMultiple ChoiceObjective-mapped

DBS-C01 Workload-Specific Database Design Practice Question

A company is designing a database for an e-commerce platform that stores product catalog data. The catalog has frequent reads and occasional writes. The data is highly relational but the team wants the lowest possible latency for read queries. Which database service should they choose?

⚠ Common exam trap

It's easy for candidates to choose Amazon RDS with read replicas (Option B) because they see 'highly relational' and assume a relational database is mandatory, but they overlook that DynamoDB can model relational data using single-table design with composite keys and that DAX provides far lower read latency than any disk-based relational database with 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 DynamoDB with DAX

Amazon DynamoDB with DAX is the best choice because the workload requires the lowest possible latency for read queries on a highly relational product catalog with frequent reads and occasional writes. DynamoDB provides single-digit millisecond latency at scale, and DAX (DynamoDB Accelerator) is an in-memory cache that reduces read latency to microseconds for eventually consistent reads, directly addressing the low-latency requirement without sacrificing the ability to handle occasional writes.

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 DocumentDB

    Why it's wrong here

    DocumentDB is a document database with millisecond latency, not microsecond.

  • Amazon RDS for PostgreSQL with read replicas

    Why it's wrong here

    RDS read replicas reduce read load but add replication lag and do not provide microsecond latency.

  • Amazon DynamoDB with DAX

    Why this is correct

    DAX provides in-memory acceleration for DynamoDB, delivering microsecond read latency.

  • Amazon ElastiCache for Redis

    Why it's wrong here

    ElastiCache is a caching layer, not a primary database, and would require additional application complexity.

About these practice questions

One of 1,663 original DBS-C01 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 →

How Courseiva writes practice questions · Editorial policy

Same concept, more angles

1 more way 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. Which TWO of the following are valid considerations when designing a database for an e-commerce application with high read traffic and low write latency requirements?

easy
  • A.Use Amazon DynamoDB Accelerator (DAX) to improve read performance.
  • B.Store session data in Amazon S3 for fast access.
  • C.Use Amazon Redshift to serve read traffic directly.
  • D.Use Amazon ElastiCache to cache frequently accessed data.
  • E.Deploy Amazon RDS for MySQL with Multi-AZ for read scaling.

Why A: Amazon DynamoDB Accelerator (DAX) is a fully managed, in-memory cache for DynamoDB that delivers up to 10x read performance improvement by reducing response times from milliseconds to microseconds. For an e-commerce application with high read traffic and low write latency requirements, DAX offloads read-heavy workloads from the DynamoDB table, ensuring consistent low-latency reads without impacting write throughput.

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.