DEA-C01 Question 316
Single answerYou are a data engineer for a retail company. The company wants to analyze customer purchasing patterns to improve its recommendation engine. The data is stored in Amazon S3 as JSON files. You need to perform ad-hoc queries to analyze this data without creating a complex data pipeline or moving the data to another service. Which AWS service should you use?
- A
Amazon Athena
- B
AWS Glue
- C
Amazon Redshift
- D
Amazon EMR
Show answer and explanation
Correct answer: A
Explanation
Amazon Athena is ideal for this scenario because it allows you to run SQL queries directly on data stored in S3 without additional infrastructure. It is specifically designed for serverless and on-demand querying, making it a perfect fit for analyzing customer purchasing patterns in JSON files stored in S3.
- A. Correct.
Amazon Athena is the correct choice for performing ad-hoc queries on data stored in S3. It allows you to query the data directly using standard SQL without needing to set up or manage any infrastructure.
- B. Incorrect.
AWS Glue is a managed ETL service used for preparing and transforming data. While it can catalog the dataset in S3, it is not designed for ad-hoc queries.
- C. Incorrect.
Amazon Redshift is a data warehouse solution. Moving the data to Redshift would require setting up a cluster and importing the data, which is unnecessary for simple ad-hoc queries.
- D. Incorrect.
Amazon EMR is a managed big data framework that supports Apache Spark and Hadoop. Using EMR for this task would add unnecessary complexity for ad-hoc querying of the data.