AWS Certified Cloud Practitioner — Question 527

A company needs to use standard SQL to query and combine exabytes of structured and semi-structured data across a data warehouse, operational database, and data lake.

Which AWS service meets these requirements?

Answer options

Correct answer: D

Explanation

Amazon Redshift supports querying exabytes of structured and semi-structured data across data lakes, operational databases, and data warehouses using features like Redshift Spectrum and Federated Query. Amazon Athena is a serverless query service primarily for S3 data lakes and is not built to act as a data warehouse itself. Amazon DynamoDB is a NoSQL database and Amazon Aurora is an OLTP relational database, meaning neither is designed for exabyte-scale analytical queries across all three environments.