Which AWS service can the company use to meet this requirement?
AWS Glue
Amazon Athena
AWS Lambda
Amazon Kinesis
Explanations:
AWS Glue is primarily a data integration service used for ETL (extract, transform, load) tasks. While it can catalog data in S3 and facilitate queries, it does not provide a direct SQL querying capability on S3 data itself.
Amazon Athena is an interactive query service that allows users to run SQL queries directly against data stored in Amazon S3. It is serverless, meaning there is no infrastructure to manage, making it an ideal choice for querying S3 data with SQL syntax.
AWS Lambda is a serverless compute service that runs code in response to events. While it can be used in conjunction with S3 for processing data, it does not provide direct SQL querying capabilities on S3 objects.
Amazon Kinesis is designed for real-time data streaming and processing. It allows for data ingestion, processing, and analysis of streaming data but does not support direct SQL queries on objects in S3.