exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 187 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 187
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company with 500,000 employees needs to supply its employee list to an application used by human resources. Every 30 minutes, the data is exported using the LDAP service to load into a new Amazon DynamoDB table. The data model has a base table with Employee ID for the partition key and a global secondary index with Organization ID as the partition key.
While importing the data, a database specialist receives ProvisionedThroughputExceededException errors. After increasing the provisioned write capacity units
(WCUs) to 50,000, the specialist receives the same errors. Amazon CloudWatch metrics show a consumption of 1,500 WCUs.
What should the database specialist do to address the issue?

  • A. Change the data model to avoid hot partitions in the global secondary index.
  • B. Enable auto scaling for the table to automatically increase write capacity during bulk imports.
  • C. Modify the table to use on-demand capacity instead of provisioned capacity.
  • D. Increase the number of retries on the bulk loading application.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
mbar94
Highly Voted 2 years, 8 months ago
Selected Answer: A
Answer A - hot partition. https://aws.amazon.com/premiumsupport/knowledge-center/dynamodb-table-throttled/
upvoted 6 times
...
aviathor
Most Recent 1 year, 11 months ago
Selected Answer: B
Given the CloudWatch metric, the error cannot be due to write capacity, so any answer consisting in adjusting write capacity has to be discarded.
upvoted 1 times
...
parle101
2 years, 3 months ago
Selected Answer: D
https://stackoverflow.com/questions/31468379/how-to-solve-throughput-error-for-dynamodb https://docs.aws.amazon.com/AWSJavaSDK/latest/javadoc/com/amazonaws/services/dynamodbv2/model/ProvisionedThroughputExceededException.html
upvoted 1 times
...
cloudsunriser
2 years, 7 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
SonamDhingra
2 years, 8 months ago
Selected Answer: A
A is correct
upvoted 1 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago