Flexible Schema Social Media Database with DynamoDB
A startup is building a social media application. User profiles, posts, and comments have relationships but the team expects rapid growth and wants to scale horizontally with no single points of failure. They need a database that supports flexible schemas for different content types. Which database service is most appropriate?
Quick Answer
Amazon DynamoDB is the correct choice for a flexible schema social media database because it is a fully managed NoSQL service that supports both key-value and document data models, allowing user profiles, posts, and comments to have varying attributes without requiring a fixed schema. This horizontal scaling capability, combined with its multi-AZ replication, eliminates single points of failure while handling rapid growth in read and write traffic. On the AWS Certified Database Specialty DBS-C01 exam, this question tests your ability to distinguish DynamoDB from relational databases like RDS, which enforce rigid schemas, and from specialized services like Neptune for graph relationships or Redshift for analytics. A common trap is choosing Neptune because social data has relationships, but DynamoDB’s flexible schema and partition-based scaling make it the general-purpose choice for high-traffic applications. Memory tip: think “Dynamo for dynamic data” — if the schema needs to flex and scale horizontally, DynamoDB is your go-to.
⚠ Common exam trap
Many exam-takers choose Amazon Neptune because the question mentions 'relationships,' but the primary requirements are flexible schemas and horizontal scaling, which DynamoDB handles better for general-purpose content storage, while Neptune is specialized for graph traversal use cases.
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 most appropriate choice because it is a fully managed NoSQL key-value and document database that supports flexible schemas, enabling the application to handle user profiles, posts, and comments with varying attributes. It scales horizontally by automatically partitioning data across multiple nodes, and its multi-AZ replication eliminates single points of failure, meeting the startup's requirements for rapid growth and high availability.
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 DynamoDB
Why this is correct
DynamoDB provides horizontal scaling, flexible schema, and high availability.
- ✗
Amazon Neptune
Why it's wrong here
Neptune is a graph database for highly connected data, not a general-purpose database for social media content.
- ✗
Amazon Redshift
Why it's wrong here
Redshift is a data warehouse for analytical queries, not transactional workloads.
- ✗
Amazon RDS for MySQL
Why it's wrong here
RDS is relational and vertical scaling is limited; horizontal scaling requires sharding which adds complexity.
Go deeper
Related to this question
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 →
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 startup is building a mobile application that needs to store user profiles and preferences. The data is schema-less and will grow rapidly. The application requires single-digit millisecond latency for reads and writes. Which AWS database should they choose?
easy- A.Amazon Aurora (MySQL compatible)
- B.Amazon Redshift
- C.Amazon RDS for SQL Server
- ✓ D.Amazon DynamoDB
Why D: Amazon DynamoDB is a fully managed NoSQL key-value and document database that delivers single-digit millisecond latency at any scale. It is schema-less, making it ideal for storing user profiles and preferences that have varying attributes, and it automatically scales to handle rapid growth without downtime or performance degradation.
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.