A web application currently experiences periods of high latency during unexpected surges in user traffic, primarily attributed to an increased volume of read operations against the platform's relational database. The database is tuned for average loads, but cannot handle these surges efficiently, which affects end-user experience. To improve performance during these peak times in a cost-effective manner, which service should a Solutions Architect recommend?
Increase the compute capacity of the database tier to handle the additional workload during traffic spikes.
Distribute the load by configuring additional replicas of the data layer across different geographical regions.
Enhance the application to contain a local caching mechanism for frequently accessed dataset.
Partition the database into smaller, more manageable datastores to spread the read demand.
Introduce a managed caching service with on-demand scalability to absorb the increased read demand on the database.