AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 251

Question

A ride-sharing company stores records for all rides in an Amazon DynamoDB table. The table includes the following columns and types of values: The table currently contains billions of items. The table is partitioned by RideID and uses TripStartTime as the sort key. The company wants to use the data to build a personal interface to give drivers the ability to view the rides that each driver has completed, based on RideStatus. The solution must access the necessary data without scanning the entire table. Which solution will meet these requirements?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Create a global secondary index (GSI) that uses DriverID as the partition key and RideStatus as the sort key.

AWS Certified Data Engineer - Associate DEA-C01 — Question 251