Field sensors for a water utility emit high-scale device telemetry with simple key-based access patterns. Architects considered forcing everything into relational RDS. What is the better database choice?
Select an answer to reveal the explanation.
Short Explanation
If the sensors just need fast key lookups at firehose scale, don’t shove them into a relational mold. DynamoDB is the purpose-built fit for that telemetry shape.
Full Explanation
Purpose-built databases should match access patterns. High-scale device telemetry with key-based access is a classic DynamoDB workload; forcing RDS adds scaling and operational friction without relational benefits. Spreadsheets on EFS and Redshift-as-OLTP are inappropriate. Selecting DynamoDB demonstrates Task 2.5 purpose-built database judgment.