Question 710
A database architecture selects caching and data-tier acceleration. The team confirms that the database struggles on repeated expensive aggregations of infrequently changing results. Which implementation most closely meets this requirement?
Explanation
Correct Answer
The scenario identifies this requirement: The database struggles on repeated expensive aggregations of infrequently changing results. Select Materialize or cache approved aggregate results with refresh rules as the specified technical mechanism. Precomputation trades freshness for lower query cost. This response addresses the problem described rather than a different design goal.
Incorrect Answers
The option Send strongly consistent reads to DynamoDB when required addresses a separate condition: cache nodes are expected to provide strongly consistent reads by default. DynamoDB accelerator caches do not replace all consistency semantics. The actual requirement is the database struggles on repeated expensive aggregations of infrequently changing results. Recommended corrective action: Materialize or cache approved aggregate results with refresh rules. Precomputation trades freshness for lower query cost.
For the alternative failure a global app needs millisecond primary-key reads in several regions, the control Use DynamoDB global tables with regional access patterns is relevant: replicated region-local data improves global latency. Here the evidence instead is the database struggles on repeated expensive aggregations of infrequently changing results. The selected technical mechanism is Materialize or cache approved aggregate results with refresh rules: precomputation trades freshness for lower query cost.
Use Amazon Redshift or suitable analytical lake services solves a different operational problem where relational analytics need billions of rows scanned quickly. Analytics warehouses optimize bulk columnar scans. It does not directly address the database struggles on repeated expensive aggregations of infrequently changing results. The case calls for Materialize or cache approved aggregate results with refresh rules, since precomputation trades freshness for lower query cost.