A company has petabytes of structured data stored in Amazon S3. They want to run complex SQL queries across this data and their existing data warehouse. They need a solution that is optimized for online analytical processing (OLAP). Which AWS service should they use?

Answer options:

Amazon RDS

Amazon Athena

Amazon Redshift

Amazon DynamoDB

How to approach this question

Match 'petabytes of structured data' and 'OLAP' to Amazon Redshift.

Full Answer

C.Amazon Redshift✓ Correct

Amazon Redshift

Amazon Redshift is a fast, fully managed data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools. It is optimized for OLAP.

Common mistakes

Choosing Athena. While Athena queries S3, Redshift is the dedicated data warehouse for complex OLAP.

Question 45 All questions Question 47

Practice the full AWS SAA-C03 Practice Exam 5

65 questions · hints · full answers · grading

More questions from this exam

Q01A company needs to grant an external auditor read-only access to specific AWS resources. The audi...Easy Q02An application running on EC2 instances needs to access objects in an S3 bucket. The security tea...Medium Q03A company is designing a VPC for a multi-tier web application. They need to block specific malici...Medium Q04A large enterprise uses AWS Organizations to manage multiple accounts. The security team wants to...Hard Q05A company hosts a web application on an Application Load Balancer (ALB). They are experiencing SQ...Medium

View all 65 questions →