A data specialist at a global e-commerce platform intends to query large volumes of transaction logs stored on a common cloud storage service, without moving the data or managing servers. The requirement is to support SQL-like queries directly on the data at rest for rapid and serverless analysis. Which service should the specialist choose?
The ideal service for the described scenario is Amazon Athena, as it provides the ability to perform interactive analyses and run SQL-like queries directly on data residing in the cloud storage service without the need to manage servers, thereby offering a serverless experience. Amazon Redshift is designed for complex and large-scale data warehousing operations and is not optimized for serverless ad-hoc queries without data movement. AWS Glue focuses on extract, transform, and load (ETL) jobs and data preparation tasks, which are more complex than required for simple SQL querying. Amazon QuickSight is a business intelligence service that specializes in creating visualizations and dashboards, rather than serving SQL queries directly on raw data.
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 are the advantages of using Amazon Athena for data querying?
Open an interactive chat with Bash
Can you explain how Amazon Athena integrates with Amazon S3?
Open an interactive chat with Bash
How does Amazon Athena compare to Amazon Redshift for data analysis?
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