Which AWS service should the company use to meet these requirements?
Amazon Elastic File System (Amazon EFS)
Amazon Redshift
Amazon RDS for MySQL
Amazon DynamoDB
Explanations:
Amazon Elastic File System (Amazon EFS) is a scalable file storage service for use with Amazon EC2. It is not designed for OLAP queries or large-scale data warehousing.
Amazon Redshift is a fully managed data warehouse service that can handle petabytes of data and is optimized for OLAP queries, making it suitable for the company’s needs.
Amazon RDS for MySQL is a relational database service suited for OLTP applications, but it does not scale efficiently for large-scale OLAP workloads compared to Redshift.
Amazon DynamoDB is a NoSQL database service optimized for high throughput and low-latency queries but is not designed for OLAP workloads or managing petabytes of data.