AWS Certified Data Analytics – Specialty — Question 164

A company's marketing team has asked for help in identifying a high performing long-term storage service for their data based on the following requirements:
✑ The data size is approximately 32 TB uncompressed.
✑ There is a low volume of single-row inserts each day.
✑ There is a high volume of aggregation queries each day.
✑ Multiple complex joins are performed.
✑ The queries typically involve a small subset of the columns in a table.
Which storage service will provide the MOST performant solution?

Answer options

Correct answer: B

Explanation

Amazon Redshift is optimized for handling large datasets and complex analytical queries, making it ideal for high-volume aggregation and joins. In contrast, Amazon Aurora MySQL is more suited for transactional workloads, Amazon Neptune specializes in graph databases, and Amazon Elasticsearch is designed for search and analytics over semi-structured data, none of which meet the specific requirements as effectively as Redshift.