Explanation
Amazon Redshift Serverless is the correct answer because:
- Amazon Redshift Serverless is a fully managed data warehouse service that automatically provisions and scales compute capacity based on workload demands
- It allows companies to run and scale analytics without having to manage data warehouse clusters, infrastructure, or capacity planning
- Users only pay for the queries they run, making it cost-effective for intermittent or unpredictable workloads
Why other options are incorrect:
- Amazon Aurora: A relational database service compatible with MySQL and PostgreSQL, but not specifically designed as a data warehouse solution
- AWS Lambda: A serverless compute service for running code without provisioning servers, not a data warehouse service
- Amazon RDS: A managed relational database service for traditional database workloads, not optimized for large-scale data analytics
Amazon Redshift Serverless provides the serverless data warehouse capability that perfectly matches the requirement of operating a data warehouse without managing infrastructure.
