A company wants to operate a data warehouse to analyze data without managing the data warehouse infrastructure. Which AWS service will meet this requirement?
A. Amazon Aurora: A relational database engine offered as part of Amazon RDS (Relational Database Service). While it is a high-performance database engine, it is optimized for transactional workloads rather than analytical processing typical of data warehouses.
B. Amazon Redshift: A fully managed, petabyte-scale data warehouse service in the cloud. It is specifically designed for analytics and data warehousing, offering fast query performance using SQL queries and integration with various business intelligence tools.
C. AWS Lambda: A serverless compute service that allows you to run code without provisioning or managing servers. It is event-driven and primarily used for executing code in response to events, such as changes in data or system state.
D. Amazon RDS: A managed relational database service that supports various database engines like MySQL, PostgreSQL, Oracle, SQL Server, and MariaDB. Similar to Amazon Aurora, it is optimized for transactional workloads rather than analytical processing.
B. Amazon Redshift: A fully managed, petabyte-scale data warehouse service in the cloud. It is specifically designed for analytics and data warehousing, offering fast query performance using SQL queries and integration with various business intelligence tools.
B. Amazon Redshift: A fully managed, petabyte-scale data warehouse service in the cloud. It is specifically designed for analytics and data warehousing, offering fast query performance using SQL queries and integration with various business intelligence tools.
"Amazon Redshift Serverless makes it easy to run analytics workloads of any size without having to manage data warehouse infrastructure."
Reference: https://aws.amazon.com/redshift/redshift-serverless/
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
TheFivePips
Highly Voted 1 year, 3 months agoAmin_013
Most Recent 3 months, 3 weeks agoShaiTay
5 months, 1 week agoRuffyit
1 year, 2 months agoNiro2023
1 year, 3 months agoSreeni_A
1 year, 5 months agoSreeni_A
1 year, 5 months agoisaphiltrick
1 year, 6 months ago