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 requirements point to a serverless data warehouse solution. Amazon Redshift Serverless is designed for this use case. It automatically provisions and scales compute resources to meet unpredictable query demands, ensuring fast performance during usage spikes. Users are billed only for the compute used when the warehouse is active. This model eliminates the need for manual cluster management (provisioning, scaling, patching), thus providing the least operational overhead. It integrates seamlessly with Amazon QuickSight in direct query mode for high-performance analytics and visualization, making it the ideal choice for consolidating data for analytics with variable workloads.

B. Amazon Athena is a query service, not a data warehouse. While it provides a serverless query experience, it is not designed for centralizing and managing consolidated data like Redshift.
C. Amazon Redshift provisioned clusters require manual capacity planning and scaling to handle unpredictable spikes, which results in significant operational overhead and potential over-provisioning costs.
D. Amazon Aurora is a relational database (OLTP) optimized for transactional workloads, not a data warehouse (OLAP) designed for fast, complex analytical queries.

1. AWS Documentation. (2023). What is Amazon Redshift Serverless?. Amazon Redshift Management Guide. Retrieved from https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-whatis.html (Describes the serverless architecture and benefits).

2. AWS Documentation. (2023). Amazon Redshift Serverless use cases. Amazon Redshift Management Guide. Retrieved from https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-use-cases.html (Highlights use cases for variable workloads and ease of use).

3. AWS Documentation. (2023). Using Amazon QuickSight with Amazon Redshift. Amazon QuickSight User Guide. Retrieved from https://docs.aws.amazon.com/quicksight/latest/user/connecting-to-redshift.html (Details the direct integration for visualization).