ExpertMedium1 markMultiple Choice
AWS SAA-C03 · Question 45 · Domain 3.3: Database Performance
A company uses Amazon DynamoDB to store user activity logs. The partition key is the UserID, and the sort key is the Timestamp. A small number of highly active users are causing ProvisionedThroughputExceededException errors, even though the overall table capacity seems sufficient. What is the MOST likely cause of this issue?
A company uses Amazon DynamoDB to store user activity logs. The partition key is the UserID, and the sort key is the Timestamp. A small number of highly active users are causing ProvisionedThroughputExceededException errors, even though the overall table capacity seems sufficient. What is the MOST likely cause of this issue?
Answer options:
A.
The table has a hot partition due to uneven data access patterns.
B.
The DynamoDB table is located in the wrong AWS Region.
C.
The sort key (Timestamp) is causing sequential writes.
D.
DynamoDB Auto Scaling is not enabled.
How to approach this question
Identify the symptom: overall capacity is fine, but specific keys are throttling. This is the definition of a 'hot partition'.
Full Answer
A.The table has a hot partition due to uneven data access patterns.✓ Correct
The table has a hot partition due to uneven data access patterns.
DynamoDB partitions data based on the partition key. Provisioned throughput is divided evenly among these partitions. If a small number of partition keys (highly active users) receive a disproportionate amount of traffic, those specific partitions will become 'hot' and throttle requests, even if the table's overall capacity is not fully utilized.
Common mistakes
Assuming Auto Scaling fixes hot partitions. It doesn't; you need to redesign the partition key to distribute traffic evenly.
Practice the full AWS SAA-C03 Practice Exam 1
65 questions · hints · full answers · grading
More questions from this exam
Q01A company has multiple AWS accounts in an AWS Organizations organization. The security team wants...MediumQ02A solutions architect is designing an application that will run on Amazon EC2 instances. The appl...EasyQ03A company wants to implement a federated identity solution for its employees to access the AWS Ma...MediumQ04A mobile application needs to access Amazon DynamoDB directly to read user-specific data. The app...HardQ05A company is hosting a web application on Amazon EC2 instances. The application connects to an Am...Medium