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?
A) Amazon Aurora MySQL
B) Amazon Redshift
C) Amazon Neptune
D) Amazon Elasticsearch

Question

Quizplus · Accepted Answer

Amazon Redshift is optimized for high-performance analysis of large datasets, supports complex queries, and is suitable for scenarios with high volumes of aggregation queries and complex joins.

A Company's Marketing Team Has Asked for Help in Identifying