ExpertMedium1 markMultiple Choice
AWS SAA-C03 · Question 46 · Domain 3.3: Database Performance
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. Which service should they use?
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. Which service should they use?
Answer options:
A.
Amazon Redshift
B.
Amazon Athena
C.
Amazon RDS
D.
Amazon EMR
How to approach this question
Match 'SQL queries against data in S3', 'serverless', and 'pay per query' with Amazon Athena.
Full Answer
B.Amazon Athena✓ Correct
Amazon Athena
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. While Redshift Spectrum can query S3, Redshift itself is a data warehouse. Athena is the pure serverless, pay-per-query tool for S3.
Practice the full AWS SAA-C03 Practice Exam 1
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...MediumQ02A solutions architect is designing an application that will run on Amazon EC2 instances. The appl...EasyQ03A company wants to implement a federated identity solution for its employees to access the AWS Ma...MediumQ04A mobile application needs to access Amazon DynamoDB directly to read user-specific data. The app...HardQ05A company is hosting a web application on Amazon EC2 instances. The application connects to an Am...Medium