A data analytics team needs to run complex SQL queries against petabytes of structured and semi-structured data stored in Amazon S3. They want a serverless solution where they only pay for the queries they run, without managing any infrastructure. <br/><br/>Which AWS service should they use?

Answer options:

Amazon Redshift

Amazon EMR

Amazon Athena

Amazon RDS

How to approach this question

Match 'serverless SQL queries against S3' directly to Amazon Athena.

Full Answer

C.Amazon Athena✓ Correct

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.

Common mistakes

Choosing Redshift, which typically requires loading data into the warehouse first.

Question 34 All questions Question 36

Practice the full AWS SAA-C03 Practice Exam 4

65 questions · hints · full answers · grading

More questions from this exam

Q01A company has multiple AWS accounts in an AWS Organizations organization. The security team wants...Medium Q02An application running on Amazon EC2 instances needs to access an Amazon DynamoDB table. Both res...Easy Q03A company is designing a web application that will be hosted on AWS. The application will use an ...Medium Q04A company is building a mobile app that requires users to authenticate using their social media a...Hard Q05A solutions architect is designing a VPC for a three-tier web application. The database tier must...Medium

View all 65 questions →