ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 539 - DVA-C01 discussion

Report
Export

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 tor this query?

A.
A global secondary index (GSI) with Product ID as the partition key and Product Rating as the sort key
Answers
A.
A global secondary index (GSI) with Product ID as the partition key and Product Rating as the sort key
B.
A global secondary index (GSI) with Product ID as the partition key and Review ID as the sort key
Answers
B.
A global secondary index (GSI) with Product ID as the partition key and Review ID as the sort key
C.
A local secondary index (LSI) with Product ID as the partition key and Product Rating as the sort key
Answers
C.
A local secondary index (LSI) with Product ID as the partition key and Product Rating as the sort key
D.
A local secondary index (LSI) with Review ID as the partition key and Product ID as the sort key
Answers
D.
A local secondary index (LSI) with Review ID as the partition key and Product ID as the sort key
Suggested answer: A
asked 16/09/2024
Jesse Moisio
43 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first