AWS Certified Data Engineer Associate DEA-C01 Practice Question
A marketing analytics team stores monthly click-stream CSV files in Amazon S3. Analysts run unpredictable, ad-hoc SQL queries a few days each month and want to visualize the results in Amazon QuickSight. The company must minimize ongoing infrastructure costs and avoid managing clusters while paying only when queries run. Which service should the data engineer recommend?
Configure Amazon Redshift Serverless with a small base RPU capacity and query the files using the COPY FROM S3 command.
Use Amazon Athena to query the S3 data and connect the dataset to QuickSight.
Create an Amazon Redshift RA3 cluster and load the CSV files into Redshift tables.
Spin up an Amazon EMR cluster with Apache Hive on demand and terminate it after each analysis window.
Amazon Athena is a serverless service that can directly query data in S3 using standard SQL and integrates with QuickSight as a data source. Athena has no infrastructure to provision or manage, and costs are incurred only for the amount of data scanned by each query, meeting the team's need for pay-per-query pricing.
Amazon Redshift (provisioned) requires running or paused clusters that still incur some cost and administration. Amazon EMR involves provisioning and maintaining a cluster (or starting and stopping it) and usually costs more for sporadic workloads. Amazon Redshift Serverless charges for the compute capacity consumed in RPUs, which can be more expensive than Athena for light, infrequent usage and still requires base capacity configuration.
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.
How does Amazon Athena work with S3 and QuickSight?
Open an interactive chat with Bash
Why is Athena more cost-effective than Amazon Redshift for infrequent workloads?
Open an interactive chat with Bash
What are the limitations of using Amazon EMR for this use case?
Open an interactive chat with Bash
What is Amazon Athena, and why is it suitable for querying data in Amazon S3?
Open an interactive chat with Bash
How does Amazon QuickSight integrate with Amazon Athena for data visualization?
Open an interactive chat with Bash
Why is Amazon Redshift not recommended for infrequent click-stream analyses in this scenario?
Open an interactive chat with Bash
AWS Certified Data Engineer Associate DEA-C01
Data Operations and Support
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 .