Question #1315
Which AWS service is optimized for running workloads that involve a data warehouse?
Amazon RDS
Amazon S3
Amazon Redshift
Amazon DynamoDB
Explanation
The correct answer is C. Amazon Redshift.
Why C is Correct:
Amazon Redshift is a fully managed, petabyte-scale data warehouse service specifically optimized for analytical workloads. It uses columnar storage, parallel query execution, and massively parallel processing (MPP) architecture to efficiently run complex queries on large datasets—key features for data warehousing.
Why Other Options Are Incorrect:
- A. Amazon RDS: A relational database service optimized for OLTP (Online Transaction Processing), not large-scale analytics.
- B. Amazon S3: A storage service for unstructured data, not a dedicated data warehouse solution (though often used alongside Redshift).
- D. Amazon DynamoDB: A NoSQL database for low-latency transactional workloads, not analytical processing.
Key Points:
- Redshift is purpose-built for data warehousing and OLAP.
- Columnar storage reduces I/O for analytical queries.
- MPP architecture scales horizontally for performance.
- Contrast with OLTP-focused services like RDS/DynamoDB.
Answer
The correct answer is: C