AWS Certified Cloud Practitioner — Question 757

A company needs a data warehouse for analytical workloads. The data warehouse must support standard SQL queries.

Which AWS service meets these requirements?

Answer options

• A. Amazon EMR
• B. Amazon Athena
• C. Amazon Redshift
• D. Amazon RDS

Correct answer: C

Explanation

Amazon Redshift is a fully managed, petabyte-scale data warehouse service designed specifically for analytical (OLAP) workloads using standard SQL queries. Amazon RDS is optimized for transactional (OLTP) workloads rather than data warehousing, while Amazon EMR is a big data processing framework and Amazon Athena is a serverless interactive query service for S3 data.