Question 241 · 712 in bank
A company has been storing monthly reports in an Amazon S3 bucket. The company exports the report data into comma-separated values (.csv) files. A developer wants to write a simple query that can read all of these files and generate a summary report. Which AWS service or feature should the developer use to meet these requirements with the LEAST amount of operational overhead?
Show answer
Answer: B
Explanation
B. Amazon Athena Amazon Athena is a serverless query service that allows you to analyze data directly in Amazon S3 using SQL queries. It supports a variety of file formats, including comma-separated values (.csv). With Athena, the developer can write SQL queries to read the .csv files stored in the Amazon S3 bucket and generate the desired summary report without the need to provision or manage infrastructure.
Source: Adapted from community discussion — Aghajee