AWS Certified Solutions Architect Associate SAA-C03 Practice Question
An online retailer is experiencing significant slowdowns during flash sales due to an increased number of customer queries to their product catalog database. To maintain customer experience, the retailer needs to implement a solution that improves query performance and can continue operations if an outage occurs in one of the data center facilities used by the retailer. Which strategy would provide the desired outcome?
Implement read replicas across distinct data center facilities.
Enable cross-region replication for the existing database instance.
Upgrade to a larger database instance to provide more compute resources.
Optimize the database by adding more indexes on frequently queried columns.