A company wants to measure the effectiveness of its recent marketing campaigns. The company performs batch processing on .csv files of sales data and stores the results in an Amazon S3 bucket once every hour. The S3 bucket contains petabytes of objects. The company runs one-time queries in Amazon Athena to determine which products are most popular on a particular date for a particular region. Queries sometimes fail or take longer than expected to finish running. Which actions should a solutions architect take to improve the query performance and reliability? (Choose two.)

Topic #: - All AWS Certified Solutions Architect - Associate SAA-C02 Questions

A. Reduce the S3 object sizes to less than 128 MB.
B. Partition the data by date and region in Amazon S3. Most Voted
C. Store the files as large, single objects in Amazon S3. Most Voted
D. Use Amazon Kinesis Data Analytics to run the queries as part of the batch processing operation.
E. Use an AWS Glue extract, transform, and load (ETL) process to convert the .csv files into Apache Parquet format.

- Awsexamhub website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Suggested Answer:

Share this post

Join the Discussion