Question #1051
A business needs to perform complex analytical queries on petabytes of structured data. They require a fully managed service that eliminates the need to manage infrastructure. Which AWS service should they use?
Amazon DynamoDB
Amazon Redshift
Amazon RDS
Amazon Kinesis Data Firehose
Explanation
Amazon Redshift (B) is optimized for online analytical processing (OLAP) and supports complex queries on petabytes of structured data using columnar storage and massively parallel processing (MPP). It is fully managed, eliminating infrastructure management.
Other options are incorrect because:
- A. DynamoDB: A NoSQL database for low-latency transactional workloads, not optimized for analytical queries.
- C. RDS: A relational database service for OLTP workloads, not designed for petabyte-scale analytics.
- D. Kinesis Data Firehose: A data ingestion service for streaming data, not for querying or analysis.
Key Points: Redshift is purpose-built for large-scale analytics, structured data, and fully managed infrastructure. Other services focus on transactional workloads, streaming, or smaller-scale operations.
Answer
The correct answer is: B