SAP-C02 Question 319
Single answerA company is designing a new application that requires high throughput for time-series data ingestion, low-latency queries, and the ability to scale seamlessly. The application will store sensor data from millions of IoT devices and requires built-in data retention policies to optimize storage costs. Which AWS database service should the company choose?
- A
Amazon RDS for PostgreSQL
- B
Amazon Redshift
- C
Amazon Timestream
- D
Amazon DynamoDB
Show answer and explanation
Correct answer: C
Explanation
Amazon Timestream is a purpose-built database designed specifically for time-series workloads. It provides features like high throughput ingestion, low-latency queries, automatic scaling, and built-in data retention policies that make it ideal for use cases like IoT sensor data storage and analysis. Other options like Amazon RDS for PostgreSQL, Amazon Redshift, and Amazon DynamoDB either lack the specific optimizations for time-series data or are designed for different types of workloads.
- A. Incorrect.
Amazon RDS for PostgreSQL is a general-purpose relational database service. While it can store time-series data, it is not optimized for high throughput ingestion or built-in retention policies specific to time-series workloads.
- B. Incorrect.
Amazon Redshift is a data warehouse solution designed for analytical workloads. It is not purpose-built for time-series data or real-time ingestion with low-latency queries.
- C. Correct.
Amazon Timestream is purpose-built for time-series data. It supports high throughput ingestion, low-latency queries, automatic scaling, and built-in data retention policies, making it an ideal choice for the described use case.
- D. Incorrect.
Amazon DynamoDB is a NoSQL database optimized for key-value and document-based workloads. While it can handle high throughput and low latency, it is not specifically designed for time-series data or built-in retention policies.