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.
Correct Answer:
Verified
Q522: A company has primary and secondary data
Q523: A company is relocating its data center
Q524: A company is investigating potential solutions that
Q525: A solutions architect is designing a new
Q526: A company is planning to migrate a
Q528: A company has migrated a two-tier application
Q529: An ecommerce company is creating an application
Q530: A company is running an application on
Q531: A company has been running a web
Q532: A company runs a web application that
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents