nerdexam
AmazonAmazon

DVA-C02 · Question #204

DVA-C02 Question #204: Real Exam Question with Answer & Explanation

Sign in or unlock DVA-C02 to reveal the answer and full explanation for question #204. The question stem and answer options stay visible for context.

Submitted by anjalisingh· Mar 5, 2026Refactoring

Question

A company has an ecommerce application. To track product reviews, the company's development team uses an Amazon DynamoDB table. Every record includes the following: - A Review ID, a 16-digit universally unique identifier (UUID) - A Product ID and User ID, 16-digit UUIDs that reference other tables - A Product Rating on a scale of 1-5 - An optional comment from the user The table partition key is the Review ID. The most performed query against the table is to find the 10 reviews with the highest rating for a given product. Which index will provide the FASTEST response for this query?

Options

  • AA global secondary index (GSI) with Product ID as the partition key and Product Rating as the
  • BA global secondary index (GSI) with Product ID as the partition key and Review ID as the sort key
  • CA local secondary index (LSI) with Product ID as the partition key and Product Rating as the sort
  • DA local secondary index (LSI) with Review ID as the partition key and Product ID as the sort key

Unlock DVA-C02 to see the answer

You've previewed enough free DVA-C02 questions. Unlock DVA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full DVA-C02 PracticeBrowse All DVA-C02 Questions