Question

Difficulty: MediumAWS Database Services

A retail company is migrating its product catalog application to AWS. The catalog contains semi-structured data with varying attributes for different product types, and needs to handle high-frequency read and write requests with single-digit millisecond latency. The development team wants to avoid managing database infrastructure, OS patching, or provisioning servers. Which AWS service is the most appropriate choice to meet these requirements?

  1. A
    Amazon RDS for MySQL
  2. Amazon DynamoDBAnswer
  3. C
    Amazon EC2 with a self-managed NoSQL database
  4. D
    Amazon Redshift

Answer

Amazon DynamoDB
Amazon DynamoDB is the correct choice because it is a fully managed, serverless NoSQL database service that provides single-digit millisecond latency at any scale. It supports flexible, semi-structured document and key-value schemas, which fit the varying attributes of a product catalog. Since it is serverless, developers do not need to provision instances, manage database infrastructure, or perform operating system patching.

Step-by-Step Solution

1
Analyze the data structure and access pattern requirements.
The application requires storing semi-structured catalog data with high-frequency, low-latency (single-digit millisecond) reads and writes, indicating a NoSQL database is needed.
This rules out relational options and analytical data warehouses which are not optimized for high-throughput, low-latency document or key-value access patterns.
2
Analyze the operational and management constraints.
The team wants to avoid server provisioning, database infrastructure management, and operating system patching, indicating a fully managed, serverless database service is required.
This rules out self-managed database options on EC2 (where patching and management fall on the customer) and self-managed scaling configurations.
3
Identify the AWS service that satisfies both sets of requirements.
Amazon DynamoDB provides a fully managed, serverless NoSQL database that scales automatically and delivers the required single-digit millisecond latency.
DynamoDB is the only listed option that is NoSQL, serverless, and completely managed by AWS, eliminating server administration tasks.

Key Concept

Selecting the appropriate AWS database service based on data structure, latency, and management overhead requirements.
Rate this question