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:

Photosystem I

A component of the photosynthesis process in plants and cyanobacteria that captures light energy for ATP and NADPH production.

Noncyclic Electron Pathway

A process in photosynthesis where electrons flow in a linear manner from water to NADP+ producing NADPH, oxygen, and ATP.

Hydrocarbon Skeleton

The backbone of organic molecules composed entirely of carbon and hydrogen atoms.

G3P

Glyceraldehyde 3-phosphate, a key intermediary molecule in both the glycolysis and Calvin cycles, involved in the metabolic process of producing energy.