A marketing firm needs to analyze extensive click-stream logs that are already stored in Amazon S3. The team wants to run quick, ad-hoc SQL queries directly against the data without first loading or transforming it into another system. Which AWS service should they use?
Amazon Athena is designed for interactive, ad-hoc analysis of data stored in Amazon S3. It is serverless, supports standard SQL, and requires no data loading or transformation. Amazon Redshift is a data-warehouse service that typically involves loading data or defining external tables. AWS Glue focuses on data preparation and ETL workflows, and Amazon QuickSight provides dashboards and visualizations rather than direct ad-hoc querying of 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 is Amazon Athena?
Open an interactive chat with Bash
How does Amazon Athena differ from Amazon Redshift?
Open an interactive chat with Bash
Why can't AWS Glue or Amazon QuickSight be used for this use case?
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...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .