Once a month, a company receives a 100 MB .csv file compressed with gzip. The file contains 50,000 property listing records and is stored in Amazon S3 Glacier. The company needs its data analyst to query a subset of the data for a specific vendor. What is the most cost-effective solution?
A) Load the data into Amazon S3 and query it with Amazon S3 Select.
B) Query the data from Amazon S3 Glacier directly with Amazon Glacier Select.
C) Load the data to Amazon S3 and query it with Amazon Athena.
D) Load the data to Amazon S3 and query it with Amazon Redshift Spectrum.

Question

Quizplus · Accepted Answer

Loading the data to Amazon S3 and querying it with Amazon Athena is cost-effective because Athena allows you to run SQL queries directly on data stored in S3 without the need for complex ETL processes or additional infrastructure.

Once a Month, a Company Receives a 100 MB