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. Which service is designed for petabyte-scale data warehousing and can query S3 directly?

Answer options:

Amazon RDS

Amazon Athena

Amazon Redshift with Redshift Spectrum

Amazon EMR

How to approach this question

Keywords: 'petabyte-scale data warehousing' and 'query S3 directly'. This points to Redshift Spectrum.

Full Answer

C.Amazon Redshift with Redshift Spectrum✓ Correct

Amazon Redshift with Redshift Spectrum

Amazon Redshift is a fast, fully managed data warehouse. Redshift Spectrum is a feature that allows you to run complex SQL queries directly against exabytes of unstructured data in Amazon S3 without having to load it into Redshift tables.

Common mistakes

Selecting Athena. While Athena queries S3, it is serverless interactive query service, not a data warehouse.

Question 44 All questions Question 46

Practice the full AWS SAA-C03 Practice Exam 3

65 questions · hints · full answers · grading

More questions from this exam

Q01A company stores sensitive documents in an Amazon S3 bucket. The security team requires that only...Easy Q02A large enterprise uses AWS Organizations to manage multiple accounts. The security team wants to...Medium Q03A company hosts a web application on Amazon EC2 instances behind an Application Load Balancer (AL...Easy Q04A company wants to continuously monitor its AWS accounts for malicious activity and unauthorized ...Medium Q05A company needs to encrypt data at rest in Amazon RDS and manage database credentials securely. T...Medium

View all 65 questions →