‹ All SAA-C03 questions

SAA-C03 Practice Question 57: DynamoDB Hot Partition Key

AWS Certified Solutions Architect – Associate (SAA-C03) · Test 6 · question 7 of 10

Database Performancehard

A telemetry service writes about 4,000 items per second, each roughly 1 KB, into a DynamoDB table whose partition key is the current date (2026-09-17) and whose sort key is a device identifier. The table is in provisioned mode with 12,000 write capacity units and auto scaling enabled, yet ThrottledRequests is high all day and CloudWatch shows consumed write capacity sitting far below what is provisioned.

What is the most effective fix?

Select one answer
Show answer and explanation

Answer:

  • D. Append a random suffix from a fixed set of values to the date partition key so that writes are spread across many partition key values

Every item written on a given day shares one partition key value, so every write lands on one physical partition. A DynamoDB partition is designed to deliver at most 1,000 write units per second, which caps this table at roughly 1,000 of the required 4,000 writes per second no matter how much capacity is provisioned table-wide. That is the signature in the metrics: heavy throttling alongside consumed capacity well under the provisioned figure. Write sharding (turning 2026-09-17 into 2026-09-17.1 through 2026-09-17.N) spreads the same traffic across N partition key values and therefore across many partitions, which is the documented remedy for a workload whose access is not uniform across partition keys.

Option A changes how capacity is billed and how the table-level ceiling is managed. It does not raise the per-partition limit, and adaptive capacity applies in both modes, so a single overloaded partition key value keeps throttling in on-demand mode too.

Option B misunderstands what an index is. You cannot write to a global secondary index directly (DynamoDB populates it from writes to the base table), so the base table's hot partition key is still in the path, and the GSI adds its own write capacity consumption on top.

Option C is a read accelerator. DAX caches reads and passes writes straight through to the table, so it neither relieves write throttling nor changes the distribution of write traffic. The problem described is entirely on the write side.

Reference: Best practices for designing and using partition keys effectively in DynamoDB

Practice Test 6 ›

Study guides for SAA-C03

AWS Developer Associate exam guide: DVA-C02 to DVA-C03AWS Developer Associate exam: DVA-C02 ends 30 November 2026 and DVA-C03 starts 1 December. What changes, which to sit, format, price and study plan.
AWS interview questions: scenarios, freshers to experiencedAWS interview questions on EC2, Lambda, S3, databases, VPC and IAM, by level, with four scenarios worked end to end and the facts old answers get wrong.
AWS Security Specialty: is it worth it, and what's testedAWS Security Specialty (SCS-C03): who it's worth it for, the six domains, new question types, price, and how it compares with CISSP.
SAA-C03 exam guide: what's on it and how to passSAA-C03 exam guide for 2026: the four domains, 65 questions in 130 minutes, price in USD and INR, the October 2026 guide update and a study plan.
AWS Service Control Policies Explained: SCPs and DenialsAWS service control policies explained: how SCPs cap permissions, why admins still get access denied, inheritance, deny vs allow lists and the exam traps.
Business Automation Examples: McDonald's to Step FunctionsBusiness automation examples from McDonald's, KFC, Ford and Toyota, the four moves they share, what to automate first, and AWS Step Functions.
How AI Is Changing Software Jobs: Where to PrepareHow AI is changing software jobs: what history shows, the evidence on junior developers, what Klarna learned, new AI roles and five domains to prepare for.
How AWS Certification Exams Work: Scoring and RenewalHow AWS certification exams work: levels, booking, question types, unscored questions, scaled scores, pass marks, validity and how recertification works.
How Netflix Uses AWS: Control Plane, CDN and ChaosHow Netflix uses AWS: the 2008 outage behind the move, control plane vs Open Connect, chaos engineering, multi-Region design and what it teaches for exams.
What Is Amazon RDS? Multi-AZ, Read Replicas and BackupsWhat is Amazon RDS? Engines, Multi-AZ, read replicas, backups, RDS Proxy, Aurora and pricing explained, with the traps that AWS exams set around each one.
What Is AWS Lambda? Triggers, Concurrency and Cold StartsWhat is AWS Lambda? How functions run, cold starts, triggers vs event source mappings, concurrency, layers, aliases, pricing and the exam traps.
What jobs can you get with AWS Cloud Practitioner?What jobs can you get with AWS Cloud Practitioner (CLF-C02)? The roles it helps with, the ones it won't land on its own, and what to add next.
AWS CloudOps Engineer Associate (SOA-C03) exam guideAWS Certified CloudOps Engineer – Associate (SOA-C03) replaced SysOps Administrator. Format, cost, the five domains, what changed and how to prepare.
Which AWS certification should you get? 2026 roadmapWhich AWS certification to get first, by role and experience, with each exam's status in October 2026, what is changing, and prices in USD and INR.
What Is AWS Glue? Data Catalog, Crawlers and ETL JobsWhat is AWS Glue? The Data Catalog, crawlers, ETL jobs and DPUs, workflows, streaming, job bookmarks, Flex and Data Quality, plus the traps AWS exams set.
AWS Edge Locations and CloudFront, ExplainedHow AWS edge locations work: CloudFront POPs, regional edge caches, the request path, edge location vs Region, and the Global Accelerator exam trap.
What Is Amazon EC2? Instances, AMIs, EBS and Auto ScalingAmazon EC2 explained: instances, AMIs, instance types, security groups, EBS, Auto Scaling groups and pricing options, with the traps AWS exams set.
Amazon S3 storage classes and lifecycle rulesHow S3 storage classes, Intelligent-Tiering and lifecycle rules work, with the retrieval fees and minimum durations that AWS exam questions turn on.
AWS disaster recovery strategies, RTO and RPOBackup and restore, pilot light, warm standby and active/active on AWS, how RTO and RPO pick between them, and the services each strategy uses.
IAM users, roles and policies on AWSHow IAM users, roles, identity-based and resource-based policies, cross-account access, SCPs and permissions boundaries fit together for AWS exams.
SQS vs SNS vs EventBridge on AWSWhen to use an SQS queue, an SNS topic or an EventBridge bus, plus fan-out, FIFO ordering, visibility timeouts and dead-letter queues for AWS exams.
The AWS shared responsibility model explainedWhat AWS secures and what you secure on EC2, RDS, Lambda and S3, how the line moves with each service, and how Cloud Practitioner questions test it.
VPC endpoints vs NAT gateways on AWSWhen to use gateway endpoints, interface endpoints (PrivateLink) or a NAT gateway for private subnets, and the cost and security trade-offs exams test.