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

Exam question from Amazon's AWS Certified Developer - Associate DVA-C02

Question #: 395
Topic #: 1

[All AWS Certified Developer - Associate DVA-C02 Questions]

A developer creates an Amazon DynamoDB table. The table has OrderID as the partition key and NumberOfItemsPurchased as the sort key. The data type of the partition key and the sort key is Number.

When the developer queries the table, the results are sorted by NumberOfItemsPurchased in ascending order. The developer needs the query results to be sorted by NumberOfItemsPurchased in descending order.

Which solution will meet this requirement?

A. Create a local secondary index (LSI) on the NumberOfItemsPurchased sort key.
B. Change the sort key from NumberOfItemsPurchased to NumberOfItemsPurchasedDescending.
C. In the Query operation, set the ScanIndexForward parameter to false.
D. In the Query operation, set the KeyConditionExpression parameter to false.

Show Suggested Answer

Suggested Answer: C 🗳️

by rdiaz at July 12, 2024, 3:40 p.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

Submit Cancel

albert_kuo

11 months, 1 week ago

Selected Answer: C

import boto3 dynamodb = boto3.resource('dynamodb') table = dynamodb.Table('YourTableName') response = table.query( KeyConditionExpression=boto3.dynamodb.conditions.Key('OrderID').eq(123), ScanIndexForward=False # decending ) items = response['Items'] for item in items: print(item)

upvoted 1 times

...

ahadh7621

11 months, 1 week ago

Selected Answer: C

This question was on my exam, July 23rd, 2024. Answer is C.

upvoted 2 times

...

komorebi

11 months, 3 weeks ago

C. In the Query operation, set the ScanIndexForward parameter to false.

upvoted 1 times

...

rdiaz

11 months, 3 weeks ago

Selected Answer: C

This approach directly addresses the requirement without the need for creating additional indexes or modifying the table schema. It leverages the existing sorting capabilities of DynamoDB and provides a straightforward solution.

upvoted 1 times

...