A ride-sharing company stores historical service usage data as structured .csv data files in Amazon S3. A data analyst needs to perform SQL queries on this data.
A solutions architect must recommend a solution that optimizes cost-effectiveness for the queries.
Which solution meets these requirements?

A. Create an Amazon EMR cluster. Load the data. Perform the queries.

B. Create an Amazon Redshift cluster. Import the data. Perform the queries.

C. Create an Amazon Aurora PostgreSQL DB cluster. Import the data. Perform the queries.

D. Create an Amazon Athena database. Associate the data in Amazon S3. Perform the queries.








 

Suggested Answer: D

Community Answer: D

Reference:
https://searchcloudcomputing.techtarget.com/answer/Compare-EMR-Redshift-and-Athena-for-data-analysis-on-AWS


This question is in SAA-C02 AWS Certified Solutions Architect – Associate Exam
For getting AWS Certified Solutions Architect – Associate Certificate




Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Amazon.
Trademarks, certification & product names are used for reference only and belong to Amazon.
The website does not contain actual questions and answers from Amazon's Certification Exam.