Exam AWS Certified Cloud Practitioner topic 1 question 432 discussion

B. Amazon Athena Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. The developer can use it to write a simple query that can read all of the .csv files in the Amazon S3 bucket and generate a summary report. Athena uses Presto, an open-source query engine, to perform the queries, and it does not require any infrastructure to be provisioned or managed. This means that the developer can use it with the least amount of operational overhead.

A. Amazon S3 Select is the answer While Athena can query data in S3, it requires setting up a database schema and potentially managing infrastructure for running queries so it doesnt meet the "LEAST amount of operational overhead" in the requirement These are the key words " write a simple query" and "LEAST amount of operational overhead" in the requirement "

least operational overhead are the keywords. Athena requires a GLUE database. A is the answer

S3 Select

A: S3 Select, since it supports CSV and works out of the box without further services

Amazon S3 Select le permite utilizar instrucciones de lenguaje de consulta estructurada (SQL) para filtrar el contenido de los objetos de Amazon S3 y recuperar exactamente el subconjunto de datos que necesita. Si utiliza Amazon S3 Select para filtrar estos datos, puede reducir la cantidad de datos que Amazon S3 transfiere, lo que reduce también los costos y la latencia para recuperarlos. Amazon S3 Select funciona con objetos almacenados en formato CSV, JSON o Apache Parquet. También funciona con objetos comprimidos con GZIP o BZIP2 (solo para objetos CSV y JSON), así como con objetos cifrados del lado del servidor. Puede especificar el formato de los resultados como CSV o JSON, y también puede determinar cómo se delimitan los registros en los resultados.

A, because the question itself asks for least operational overhead and required a simple query Amazon S3 Select, you can use structured query language (SQL) statements to filter the contents of an Amazon S3 object and retrieve only the subset of data that you need. By using Amazon S3 Select to filter this data, you can reduce the amount of data that Amazon S3 transfers, which reduces the cost and latency to retrieve this data. Amazon S3 Select works on objects stored in CSV, JSON, or Apache Parquet format.

B. Amazon Athena

B is the answer.

Analytics on top of S3 Data => Amazon Athena

It is B

Yes, it's B

s3 select only runs queries on a single object , while Athena can operate on multiple.. The question mentions CVS FILES... I say Athena

https://aws.amazon.com/blogs/aws/amazon-athena-interactive-sql-queries-for-data-in-amazon-s3/

https://aws.amazon.com/s3/features/#s3-select