Courseiva
Workload-Specific Database DesigneasyMultiple ChoiceObjective-mapped

DBS-C01 Workload-Specific Database Design Practice Question

A startup is building a mobile app backend with user profiles and social features. They need a database that can handle flexible schemas, high read throughput for user profiles, and strong consistency for friend requests. Which database service should they choose?

⚠ Common exam trap

A common mix-up: candidates choose Amazon Neptune for social features due to its graph capabilities, overlooking that DynamoDB can handle simple social relationships with strong consistency and lower operational overhead, while Neptune's eventual consistency and complexity are mismatched for this use case.

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

Amazon DynamoDB is the correct choice because it provides flexible schemas (schema-less tables) ideal for user profiles that may vary in attributes, supports high read throughput via auto-scaling and DAX caching, and offers strongly consistent reads (when requested) to ensure friend requests are processed reliably. Its fully managed nature and single-digit millisecond latency align with the startup's need for a scalable, consistent 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 RDS for MySQL

    Why it's wrong here

    RDS requires fixed schema and may not scale as easily for high throughput.

  • Amazon Neptune

    Why it's wrong here

    Neptune is for graph data; not ideal for simple profile storage.

  • Amazon DynamoDB

    Why this is correct

    DynamoDB provides flexible schema and high performance with strong consistency.

  • Amazon DocumentDB

    Why it's wrong here

    DocumentDB is document-oriented but may have higher latency for strongly consistent reads.

About these practice questions

Courseiva writes every DBS-C01 question from scratch — 1,663 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. 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. A company is building a document management system where each document can have multiple attributes (tags) that need to be queried efficiently. The workload is write-heavy with occasional reads. Which database is best suited?

medium
  • A.Amazon QLDB
  • B.Amazon DynamoDB
  • C.Amazon ElastiCache for Redis
  • D.Amazon RDS for MySQL

Why B: Amazon DynamoDB is the best choice for a write-heavy, document management system with tag-based queries because it is a fully managed NoSQL key-value and document database that delivers single-digit millisecond performance at any scale. Its flexible schema allows each document to have multiple attributes (tags) without predefined schemas, and its secondary indexes (LSI/GSI) enable efficient querying on those tags. DynamoDB's auto-scaling and provisioned throughput are designed to handle high write volumes, while occasional reads benefit from its consistent low-latency access.

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.