Amazon Exam DVA-C02 Topic 6 Question 22 Discussion

Actual exam question for Amazon's DVA-C02 exam

Question #: 22
Topic #: 6

A company runs an application on AWS The application stores data in an Amazon DynamoDB table Some queries are taking a long time to run These slow queries involve an attribute that is not the table's partition key or sort key

The amount of data that the application stores in the DynamoDB table is expected to increase significantly. A developer must increase the performance of the queries.

Which solution will meet these requirements'?

AIncrease the page size for each request by setting the Limit parameter to be higher than the default value Configure the application to retry any request that exceeds the provisioned throughput.

BCreate a global secondary index (GSI). Set query attribute to be the partition key of the index

CPerform a parallel scan operation by issuing individual scan requests in the parameters specify the segment for the scan requests and the total number of segments for the parallel scan.

DTurn on read capacity auto scaling for the DynamoDB table. Increase the maximum read capacity units (RCUs).

Show Suggested Answer

Suggested Answer: B

Global Secondary Index (GSI):GSIs enable alternative query patterns on a DynamoDB table by using different partition and sort keys.

Addressing Query Bottleneck:By making the slow-query attribute the GSI's partition key, you optimize queries on that attribute.

Scalability:GSIs automatically scale to handle increasing data volumes.

Amazon DynamoDB Global Secondary Indexes:https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/GSI.html

by Clay at Mar 16, 2024, 09:30 AM

Limited Time Offer

25%

Off

Get Premium DVA-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Merrilee

7 days ago

Haha, I love how these DynamoDB questions always involve some kind of performance issue. It's like the AWS exam writers are just trying to keep us on our toes, you know? But yeah, I think the GSI is the way to go here. It's a classic DynamoDB solution for this kind of problem.

upvoted 0 times

...

Kattie

8 days ago

I'm not so sure about the GSI option. Isn't that going to cost more in terms of provisioned throughput? And what if the queries change in the future, then we'd have to update the index. I'm kind of leaning towards the auto-scaling option - that seems like a more hands-off and potentially cheaper solution.

upvoted 0 times

...

Rosann

9 days ago

I agree, the GSI option does seem like the best choice here. The partition key will allow for fast lookups, and it won't require any changes to the application code. Plus, it's a more scalable solution than just increasing the page size or doing a parallel scan.

upvoted 0 times

...

Adela

10 days ago

Hmm, this is an interesting question. The slow queries due to the non-key attributes are definitely a concern, especially with the expected increase in data. I'm leaning towards option B - creating a global secondary index (GSI) with the query attribute as the partition key. That seems like the most straightforward way to improve query performance.

upvoted 0 times

...