Which AWS service meets these requirements?
Amazon EMR
Amazon Athena
Amazon Redshift
Amazon RDS
Explanations:
Amazon EMR (Elastic MapReduce) is primarily designed for big data processing and analytics using frameworks like Hadoop and Spark, not specifically as a data warehouse for SQL queries.
Amazon Athena is a serverless query service that allows users to analyze data in S3 using standard SQL. However, it is not a data warehouse; it’s better suited for ad-hoc querying and does not support persistent storage for structured data.
Amazon Redshift is a fully managed, petabyte-scale data warehouse service that supports standard SQL queries. It is specifically designed for analytical workloads and allows users to run complex queries on large datasets efficiently.
Amazon RDS (Relational Database Service) is a managed relational database service that supports several database engines. While it supports SQL queries, it is not optimized for large-scale analytical workloads like a data warehouse.