ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Developer - Associate DVA-C02 All Questions

View all questions & answers for the AWS Certified Developer - Associate DVA-C02 exam
Go to Exam

Exam AWS Certified Developer - Associate DVA-C02 topic 1 question 189 discussion

Exam question from Amazon's AWS Certified Developer - Associate DVA-C02
Question #: 189
Topic #: 1
[All AWS Certified Developer - Associate DVA-C02 Questions]

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?

  • 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
  • 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
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by fordiscussionstwo at Oct. 6, 2023, 2:47 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
65703c1
5 months, 1 week ago
Selected Answer: A
A is the correct answer.
upvoted 2 times
...
KarBiswa
8 months ago
Selected Answer: A
Rating for a product these two are essential and already ReviewID has partitions
upvoted 2 times
...
SerialiDr
9 months, 2 weeks ago
Selected Answer: A
This GSI allows for queries that are based on Product ID, efficiently narrowing down the reviews for a specific product. The Product Rating as the sort key enables sorting the reviews by their rating, which directly supports the need to find the top 10 reviews. GSIs also support a different partition key than the base table, which is necessary in this case since the base table's partition key is Review ID.
upvoted 3 times
...
dilleman
1 year ago
Selected Answer: A
A should be correct
upvoted 3 times
...
Digo30sp
1 year ago
Selected Answer: A
A) https://www.examtopics.com/discussions/amazon/view/88995-exam-aws-certified-developer-associate-topic-1-question-362/
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago