A marketing company is storing its campaign response data in Amazon S3. A consistent set of sources has generated the data for each campaign. The data is saved into Amazon S3 as .csv files. A business analyst will use Amazon Athena to analyze each campaign's data. The company needs the cost of ongoing data analysis with Athena to be minimized. Which combination of actions should a data analytics specialist take to meet these requirements? (Choose two.)
A) Convert the .csv files to Apache Parquet.
B) Convert the .csv files to Apache Avro.
C) Partition the data by campaign.
D) Partition the data by source.
E) Compress the .csv files.

Question

Quizplus · Accepted Answer

The Answer of A marketing company is storing its campaign response data in Amazon S3. A consistent set of sources has generated the data for each campaign. The data is saved into Amazon S3 as .csv files. A business analyst will use Amazon Athena to analyze each campaign's data. The company needs the cost of ongoing data analysis with Athena to be minimized. Which combination of actions should a data analytics specialist take to meet these requirements? (Choose two.)
A) Convert the .csv files to Apache Parquet.
B) Convert the .csv files to Apache Avro.
C) Partition the data by campaign.
D) Partition the data by source.
E) Compress the .csv files.

A Marketing Company Is Storing Its Campaign Response Data in Amazon