A company wishes to analyze their vast collection of unstructured text data stored in S3. They need a service that allows them to run interactive SQL queries directly on their data stored in Amazon S3 without having to load the data into a separate analytics platform. Which service would be BEST suited for this task?
Amazon Athena is designed for running interactive queries on data stored in Amazon S3 using standard SQL without the need to load the data into a separate analytics platform or data warehouse. Hence, for the described scenario where a company needs to run interactive SQL queries directly on their unstructured text data stored in S3, Amazon Athena is the best choice. Other data analytics services like Amazon Kinesis and AWS Glue would not be the best fit for this scenario. Amazon Kinesis is used for real-time data streaming and analytics, and AWS Glue is a fully managed extract, transform, and load (ETL) service that prepares and loads data for analytics, but neither provide the ability to run SQL queries directly on data stored in S3 like Athena does.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Amazon Athena and how does it work?
Open an interactive chat with Bash
What types of data can be analyzed with Amazon Athena?
Open an interactive chat with Bash
How does Amazon Athena differ from AWS Glue?
Open an interactive chat with Bash
AWS Cloud Practitioner CLF-C02
Cloud Technology and Services
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
IT & Cybersecurity Package Join Premium for Full Access