ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 49 - CLF-C02 discussion

Report
Export

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?

A.
Amazon S3 Select
Answers
A.
Amazon S3 Select
B.
Amazon Athena
Answers
B.
Amazon Athena
C.
Amazon Redshift
Answers
C.
Amazon Redshift
D.
Amazon EC2
Answers
D.
Amazon EC2
Suggested answer: B

Explanation:

Amazon Athena is the AWS service that the developer should use to write a simple query that can read all of the .csv files stored in an Amazon S3 bucket and generate a summary report. Amazon Athena is an interactive query service that allows users to analyze data in Amazon S3 using standard SQL. Amazon Athena does not require any server setup or management, and users only pay for the queries they run. Amazon Athena can handle various data formats, including .csv, and can integrate with other AWS services such as Amazon QuickSight for data visualization

asked 16/09/2024
Reece Scarley
43 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first