Courseiva
Workload-Specific Database DesignhardMultiple SelectObjective-mapped

DBS-C01 Workload-Specific Database Design Practice Question

A company is designing a database for a social media analytics platform that requires: 1) storing relationships between users, posts, and interests; 2) running complex graph queries like 'find all friends of friends who like topic X'; 3) high availability with multi-region replication. Which TWO AWS services should they consider? (Choose TWO.)

⚠ Common exam trap

Many candidates confuse DynamoDB Global Tables (which provides multi-region replication) with graph database capabilities, overlooking that DynamoDB lacks native graph query support for multi-hop traversals like 'friends of friends'.

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 Neptune

Amazon Neptune is a fully managed graph database service optimized for storing and querying highly connected data, such as user, post, and interest relationships. It supports property graph and RDF models, enabling complex graph queries like 'find all friends of friends who like topic X' using Gremlin or SPARQL. This directly satisfies the requirement for graph query capabilities. Amazon Aurora Global Database provides multi-region replication with low-latency global read operations and automatic failover, meeting the high availability and multi-region replication requirement. Together, Neptune handles the graph query workload, while Aurora Global Database provides the global distribution and disaster recovery needed for the analytics platform.

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 Neptune

    Why this is correct

    Neptune is purpose-built for graph queries.

  • Amazon Redshift

    Why it's wrong here

    Redshift is for data warehousing, not graph queries.

  • Amazon Aurora Global Database

    Why this is correct

    Aurora Global Database provides multi-region replication for relational data; can be used alongside Neptune.

  • Amazon DynamoDB with Global Tables

    Why it's wrong here

    DynamoDB is not a graph database.

  • Amazon ElastiCache for Redis

    Why it's wrong here

    ElastiCache is for caching, not graph storage.

About these practice questions

This DBS-C01 question is part of Courseiva's 1,663-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 →

How Courseiva writes practice questions · Editorial policy

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.