A data analyst needs to run ad-hoc SQL queries on CSV files stored in Amazon S3. They want a serverless solution that requires zero infrastructure setup. Which service should they use?

Answer options:

Amazon RDS

Amazon Redshift

Amazon Athena

AWS Glue

How to approach this question

Look for 'serverless SQL on S3'.

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 is not serverless (unless using Redshift Serverless, but Athena is the standard answer for ad-hoc S3 queries).

Question 51 All questions Question 53

Practice the full AWS SAA-C03 Practice Exam 2

65 questions · hints · full answers · grading

More questions from this exam

Q01A company wants to ensure that no AWS resources can be created in the ap-northeast-1 region acros...Easy Q02A web application runs on Amazon EC2 instances behind an Application Load Balancer (ALB). The com...Easy Q03A company is storing highly sensitive data in an Amazon S3 bucket. The security team requires tha...Medium Q04An application running on an EC2 instance needs to access an Amazon DynamoDB table in a different...Hard Q05A company needs to store database credentials securely. The credentials must be automatically rot...Medium

View all 65 questions →