Question 320
During a design review, the team identifies the following need: A DynamoDB table's read latency increases because every request scans the full table to find orders by customer status. Which AWS design is the most defensible?
Explanation
Correct Answer
Key-based Query patterns scale better than repeated scans for selective access. This design addresses the specific constraint: A DynamoDB table's read latency increases because every request scans the full table to find orders by customer status. A meaningful acceptance check is: Target queries return expected orders using the index with lower read capacity.
Incorrect Answers
Schema joins and complex multi-row transactions often fit relational engines better than a forced key-value model.
Database proxies reduce repeated connection setup and limit connection storms from serverless clients.
Redis/Memcached caching reduces repeated database reads but needs consistency safeguards.