Answer-first summary for fast verification
Answer: Amazon Athena, offering serverless SQL analytics on S3 data.
The correct answer is B, Amazon Athena. Athena is an interactive query service that allows users to run SQL-like queries directly against data stored in S3. It's serverless, so there's no infrastructure to manage, and you only pay for the queries you run. This makes it an ideal choice for the scenario described, where a developer needs to generate a summary report from .csv files in S3 with minimal operational overhead. S3 Select (option A) is also a good option for querying data in S3, but it's more suited for filtering data within a single object rather than running complex queries across multiple files. Options C and D, Amazon Redshift and EC2, respectively, would involve more operational overhead and are not the best fit for this use case.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which AWS service is best suited for a developer to query and generate a summary report from multiple .csv files in an S3 bucket with minimal operational overhead?
A
Amazon S3 Select, for SQL-based filtering of S3 object contents.
B
Amazon Athena, offering serverless SQL analytics on S3 data.
C
Amazon Redshift, a managed data warehouse service.
D
Amazon EC2, providing scalable compute capacity with more management overhead.
No comments yet.