AWS Certified Cloud Practitioner — Question 874

A company needs to generate reports for business intelligence and operational analytics on petabytes of semistructured and structured data. These reports are produced from standard SQL queries on data that is in an Amazon S3 data lake.
Which AWS service provides the ability to analyze this data?

Answer options

• A. Amazon RDS
• B. Amazon Neptune
• C. Amazon DynamoDB
• D. Amazon Redshift

Correct answer: D

Explanation

Amazon Redshift, particularly through Redshift Spectrum, enables users to run complex SQL queries against petabytes of structured and semistructured data stored directly in Amazon S3. The other options (Amazon RDS, Amazon Neptune, and Amazon DynamoDB) are designed for relational, graph, and NoSQL database workloads respectively, rather than directly querying large-scale S3 data lakes for business intelligence.