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

question 465

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.

---

Definitions:

Sandstone

A sedimentary rock composed mostly of sand-sized minerals or rock grains.

Shales

Fine-grained sedimentary rocks formed from silt and clay particles, known for their ability to split into thin layers.

Salt Domes

Geological formations created when masses of salt are forced upward through overlying sediments, often associated with oil deposits.

Sedimentary Rocks

Rocks formed by the deposition and subsequent cementation of mineral or organic particles on the floor of oceans, lakes, or rivers.