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?

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.
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.

Report Issue

Answer Description

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.