An e-commerce platform is experiencing sporadic performance degradation during peak times, which has been traced back to dynamically generated content that requires complex database queries. What approach should a Solutions Architect take to minimize database load and provide consistent response times?
Upgrade to a larger database instance size to better handle peak loads.
Implement Amazon ElastiCache with an eviction policy suitable for dynamic content caching, like Least Recently Used (LRU).
Deploy AWS Global Accelerator to improve application performance under high user demand.
Enable cross-region read replicas for the database to distribute the read load.