A company uses a variety of AWS and third-party data stores. The company wants to consolidate all the data into a central data warehouse to perform…

The solution requires a central data warehouse with fast query performance for analytics, low operational overhead, and the ability to handle unpredictable, spiky workloads. Amazon Redshift Serverless is the ideal choice as it is a purpose-built data warehouse designed for high-performance analytics. Its serverless architecture automatically provisions and scales compute resources to match workload demands, including unpredictable spikes. This auto-scaling capability, combined with not having to manage clusters, directly addresses the requirement for the least operational overhead while ensuring fast query responses for Amazon QuickSight in direct query mode.

1. Amazon Redshift Documentation - Amazon Redshift Serverless: "With Amazon Redshift Serverless

you can run and scale analytics without having to provision and manage data warehouse clusters... Amazon Redshift Serverless automatically provisions and intelligently scales data warehouse capacity to deliver high performance for demanding and unpredictable workloads."

Source: AWS Documentation. (2023). What is Amazon Redshift Serverless? Amazon Redshift Management Guide.

2. Amazon Redshift Documentation - Choosing between provisioned clusters and serverless: "Choose Amazon Redshift Serverless when you want to get started quickly and when you have variable workloads or unpredictable usage patterns... It eliminates the need to provision and manage clusters."

Source: AWS Documentation. (2023). Overview of Amazon Redshift Serverless. Amazon Redshift Management Guide.

3. Amazon Web Services - Amazon Athena: "Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL... Athena is serverless

so there is no infrastructure to manage." While serverless

its primary use case is ad-hoc querying on S3

whereas Redshift is a performance-optimized data warehouse.

Source: AWS Documentation. (2023). What is Amazon Athena? Amazon Athena User Guide.

4. Amazon Web Services - Amazon Aurora: "Amazon Aurora is a relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases... It is designed for online transaction processing (OLTP) workloads."

Source: AWS Documentation. (2023). What is Amazon Aurora? Amazon Aurora User Guide.