Question 140
A reviewer is validating the change select an appropriate RDS/Aurora relational database and size/read-scale based on transactional query requirements. Which observed outcome best proves the requirement has been met?
Explanation
Correct Answer
Schema joins and complex multi-row transactions often fit relational engines better than a forced key-value model. The selected observation directly tests this design: Required SQL joins and transactions work correctly under peak load and have measured capacity. The design requirement was: A data-intensive app needs joins and ACID relational transactions but developers propose DynamoDB because it can auto scale.
Incorrect Answers
Columnar analytical warehouses optimize large aggregations differently from OLTP relational databases.
Time-indexed storage patterns differ from generic transactional relational models for telemetry.
Engine compatibility and HA requirements should drive database selection, not an unrelated NoSQL feature.