DBS-C01 Workload-Specific Database Design Practice Question
A company needs to store and analyze JSON documents that contain nested fields. The data is used for real-time dashboards and ad-hoc queries. The team wants a fully managed solution that supports both key-value lookups and SQL-like queries. Which AWS service should they use?
⚠ Common exam trap
Many exam-takers choose Amazon DocumentDB because it is a document database, but they overlook DynamoDB's superior key-value lookup performance and PartiQL's SQL-like query capability, which are explicitly required for real-time dashboards and ad-hoc queries in a fully managed serverless environment.
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 correct because it is a fully managed NoSQL key-value and document database that supports single-digit millisecond latency for key-value lookups, and its PartiQL-compatible query language enables SQL-like queries on JSON documents with nested fields. DynamoDB also integrates with AWS services like Lambda and Kinesis for real-time dashboards, and its adaptive capacity handles ad-hoc query patterns without manual scaling.
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 supports JSON documents, key-value lookups, and PartiQL for SQL-like queries.
- ✗
Amazon Redshift
Why it's wrong here
Redshift is a data warehouse, not designed for real-time key-value lookups.
- ✗
Amazon RDS for PostgreSQL with JSONB
Why it's wrong here
PostgreSQL supports JSON but is not key-value and requires server management.
- ✗
Amazon DocumentDB
Why it's wrong here
DocumentDB is a document database but does not natively support key-value access patterns.
Quick reference
Cloud Service Model Comparison
| Model | You Manage | Provider Manages | Examples |
|---|---|---|---|
| IaaS | OS, runtime, apps, data | Hardware, hypervisor, networking | EC2, Azure VMs, GCP Compute Engine |
| PaaS | Apps and data | OS, runtime, middleware, hardware | Elastic Beanstalk, Azure App Service |
| SaaS | Data and settings only | Everything else | Microsoft 365, Salesforce, Workday |
| FaaS / Serverless | Function code only | Infra, scaling, runtime | Lambda, Azure Functions, Cloud Run |
| CaaS | Containers and apps | Kubernetes, OS, hardware | EKS, AKS, GKE |
Go deeper
Related to this question
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 →
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.