A Ride-Sharing Company Stores Historical Service Usage Data as Structured

Multiple Choice

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.