DEA-C01 Question 320
Single answerA retail company collects transactional data from its point-of-sale systems and stores it in an Amazon S3 bucket. The company wants to analyze this data to calculate daily sales trends and generate on-demand reports. Which AWS service or combination of services should the company use to efficiently analyze this data?
- A
Use Amazon Athena to query the data directly from the S3 bucket and generate the required sales reports.
- B
Use AWS Glue to transform the data into a relational format and load it into Amazon Redshift for analysis.
- C
Use Amazon EMR to process the data and store the results in Amazon DynamoDB for report generation.
- D
Use AWS Data Pipeline to transfer the data to Amazon RDS for analysis and report generation.
Show answer and explanation
Correct answer: A
Explanation
Amazon Athena is the best choice for analyzing data stored in S3 because it eliminates the need for data movement and allows direct querying using SQL. This makes it a cost-effective and efficient solution for generating daily sales trends and on-demand reports in this scenario.
- A. Correct.
This is the correct option. Amazon Athena allows querying data stored in S3 directly using standard SQL, making it a cost-effective and scalable solution for ad hoc analysis and report generation.
- B. Incorrect.
Although AWS Glue and Amazon Redshift can be used together for large-scale data transformations and analysis, this approach adds unnecessary complexity and cost for this use case. The data is already in S3, and Athena is more suitable for on-demand analysis.
- C. Incorrect.
Amazon EMR is ideal for large-scale data processing but is not necessary for this scenario. Storing the results in DynamoDB for reporting is also inefficient for analytical workloads.
- D. Incorrect.
AWS Data Pipeline is typically used for data movement and orchestration, not for direct data analysis. Transferring data to Amazon RDS adds extra complexity and cost, which is unnecessary for this use case.