Which AWS NoSQL Database Meets Global OLTP with Least Overhead?

Choose a data store.
Answer Correct answer: C — Amazon DynamoDB delivers fully managed, globally available NoSQL OLTP with single-digit millisecond latency and minimal operational overhead.

A gaming company uses a NoSQL database to store customer information. The company is planning to migrate to AWS. The company needs a fully managed AWS solution that will handle high online transaction processing (OLTP) workload, provide single-digit millisecond performance, and provide high availability around the world. Which solution will meet these requirements with the LEAST operational overhead?

  1. Amazon Keyspaces (for Apache Cassandra)
  2. Amazon DocumentDB (with MongoDB compatibility)
  3. Amazon DynamoDB Correct Answer
  4. Amazon Timestream

Community Votes

C
100%

100% of anonymous learners picked answer C. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

The exam tests matching AWS database services to workload characteristics; the trap is choosing a compatible-engine service like Keyspaces or DocumentDB when the question asks for DynamoDB's global OLTP and minimal-ops profile.

This DEA-C01 question tests which fully managed AWS NoSQL service delivers single-digit millisecond OLTP performance and global high availability with the least operational overhead. The answer is Amazon DynamoDB (C), because its global tables and serverless scaling match every stated requirement.

A frequent mistake is selecting Amazon DocumentDB because it is a managed NoSQL database, but MongoDB compatibility and instance-based clusters add operational overhead and do not match DynamoDB's global table and single-digit millisecond positioning.

Community Discussion (5 comments)

JUNGAWS 👍 7 Selected: C
provide single-digit millisecond performance => DynamoDB
GustonMari 👍 1
Also RDS and DynamoDB = OLTP
HunkyBunky 👍 1 Selected: C
No doubt - DynamoDB
tgv 👍 2 Selected: C
Amazon DynamoDB is the most appropriate choice given the company's requirements for high performance, global availability, and minimal operational overhead.
JUNGAWS 👍 3
C provide single-digit millisecond performance => DynamoDB

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Expert Analysis

Why the Answer Is Correct

Amazon DynamoDB is AWS's fully managed NoSQL key-value and document database designed for high-throughput OLTP, with consistent single-digit millisecond latency at virtually any scale. It supports global tables for multi-Region, active-active replication, which directly satisfies "high availability around the world." Because it is serverless/on-demand capable and handles provisioning, patching, replication, and scaling, it meets the "LEAST operational overhead" requirement better than the other managed NoSQL engines. The question's clues — NoSQL, OLTP, single-digit millisecond, global — map to DynamoDB's documented positioning.

Why the Other Options Are Wrong

Amazon Keyspaces is a managed Apache Cassandra-compatible service, but the question does not require Cassandra API compatibility, and migrating customer information to it would typically add more design and operations work than DynamoDB's native global tables and on-demand capacity. Amazon DocumentDB is MongoDB-compatible and aimed at document workloads, but it is not the default exam answer for global single-digit millisecond OLTP with least ops; its global clusters and instance-based scaling can introduce more capacity planning. Amazon Timestream is a time-series database optimized for IoT and operational metrics, not general customer information OLTP. Thus A, B, and D all miss at least one explicit requirement or add unnecessary operational complexity.

Community Comment Notes

JUNGAWS focused on the latency clue, paraphrasing that "single-digit millisecond performance => DynamoDB." tgv agreed that DynamoDB fits high performance, global availability, and minimal operational overhead. GustonMari added that "RDS and DynamoDB = OLTP," which reinforces the OLTP positioning. HunkyBunky was blunt: "No doubt - DynamoDB." Across the visible comments the consensus is unanimous for DynamoDB, and the reasoning aligns with the official AWS service characteristics.

Official Reference

Exam Strategy

When a DEA-C01 question repeats latency, OLTP, global availability, and least operational overhead together, map those keywords directly to DynamoDB before considering compatible-engine services. Also watch for clues such as "time-series" or "MongoDB compatibility," which would redirect you to Timestream or DocumentDB.

Frequently Asked Questions

Why is Amazon Keyspaces not the answer if it is also a managed NoSQL database?

Keyspaces targets Cassandra-compatible workloads and can require more capacity and migration design; the question asks for the least-overhead global OLTP solution, which DynamoDB addresses natively.

Does Amazon DocumentDB provide single-digit millisecond performance?

DocumentDB can deliver low-latency document reads, but it is optimized for MongoDB compatibility rather than the global, serverless OLTP profile described in the question.

Related Analysis

Practice All DEA-C01 Questions

Access 100 questions with complete answers and detailed explanations.

View Full DEA-C01 Practice Test →

← Back to DEA-C01 Study Guide