Explanation
Amazon Redshift is the correct choice for a petabyte-scale data warehouse because:
- Amazon Redshift is AWS's fully managed, petabyte-scale data warehousing service specifically designed for large-scale analytics and business intelligence workloads
- It can handle petabytes of data and provides high-performance querying capabilities
Why other options are incorrect:
- Amazon DynamoDB is a NoSQL database service for key-value and document data, not designed for data warehousing
- Amazon RDS is a relational database service for OLTP (Online Transaction Processing) workloads, not optimized for large-scale analytics
- Amazon ElastiCache is an in-memory caching service for improving application performance, not for data warehousing
Amazon Redshift is purpose-built for data warehousing scenarios where you need to analyze massive amounts of structured data across multiple dimensions.