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, serverless analysis. Which service should the specialist choose?
Amazon Athena is the best fit because it is a fully managed, serverless interactive query service that lets you run standard SQL on data stored directly in Amazon S3-no infrastructure to provision or manage, and no data loading required.
Amazon Redshift is a managed cloud data warehouse optimized for large-scale, persistent analytic workloads. Although Redshift Serverless and Redshift Spectrum can query S3 data without clusters, they still involve setting up database objects and are generally chosen for sustained data-warehouse use cases rather than lightweight, ad-hoc exploration of raw log files.
AWS Glue is a serverless data integration service used to build and orchestrate ETL pipelines; it is aimed at preparing and moving data rather than interactively querying it.
Amazon QuickSight is a business-intelligence service for creating visualizations and dashboards; it relies on data sources such as Athena or Redshift for query processing and does not itself provide direct SQL querying against raw S3 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