A company has 5 TB of data stored in Amazon S3.The company plans to occasionally run queries on the data for analysis.
Which AWS service should the company use to run these queries in the MOST cost-effective manner?
Amazon Redshift
Amazon Athena
Amazon Kinesis
Amazon RDS
Explanations:
Amazon Redshift is primarily a data warehouse solution, which may incur higher costs for occasional querying.
Amazon Athena allows for serverless querying of data in S3 using SQL, making it cost-effective for occasional queries since you only pay for the queries you run.
Amazon Kinesis is designed for real-time data streaming and is not ideal for querying static data in S3.
Amazon RDS is a managed relational database service, which would likely be more expensive and unnecessary for occasional queries on S3 data.
Based on what I know, the answer is:
Amazon Athena