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?
Enable cross-region replication for the existing database instance.
Optimize the database by adding more indexes on frequently queried columns.
Implement read replicas across distinct data center facilities.
Upgrade to a larger database instance to provide more compute resources.
Implementing read replicas in various data center facilities (Availability Zones) not only spreads the load of customer queries across multiple sources but also ensures that the application can failover to other replicas in case of an outage. This is the most effective solution to address both read traffic performance and availability concerns without changing the primary data source configuration. Adding indexes may improve query performance but will not address the potential for an outage. Making the database instance larger will increase overall capacity but is a less targeted solution for read scalability and does not provide multi-facility resilience. Enabling cross-region replication adds geographical distribution but could introduce additional latency for the reads and doesn't address the immediate need to spread the read load.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What are read replicas and how do they work?
Open an interactive chat with Bash
What are Availability Zones and why are they important for reliability?
Open an interactive chat with Bash
What are the limitations of simply adding more indexes to a database?