AWS Certified Cloud Practitioner — Question 411

A company needs to implement an AWS data warehouse solution that can manage petabytes of data. A reporting application will perform online analytic processing (OLAP) queries on the data.

Which AWS service should the company use to meet these requirements?

Answer options

Correct answer: B

Explanation

Amazon Redshift is a fully managed, petabyte-scale data warehouse service designed specifically for online analytical processing (OLAP) and complex analytical queries. Amazon RDS for MySQL is an OLTP relational database, while Amazon DynamoDB is a NoSQL database, making neither suitable for petabyte-scale OLAP warehousing. Amazon Elastic File System (Amazon EFS) is a shared file system and does not offer data warehousing or query execution capabilities.