DBS-C01 · Question #233
A company has branch offices in the United States and Singapore. The company has a three-tier web application that uses a shared database. The database runs on an Amazon RDS for MySQL DB instance that
The correct answer is B. Create an RDS read replica in ap-southeast-1 from the primary DB instance in us-west-2.. To resolve slow dashboard loading for users in Singapore connected to an Amazon RDS MySQL database in us-west-2, the most operationally efficient solution is to create an Amazon RDS read replica in the ap-southeast-1 region.
Question
A company has branch offices in the United States and Singapore. The company has a three-tier web application that uses a shared database. The database runs on an Amazon RDS for MySQL DB instance that is hosted in the us-west-2 Region. The application has a distributed front end that is deployed in us-west-2 and in the ap-southeast-1 Region. The company uses this front end as a dashboard that provides statistics to sales managers in each branch office. The dashboard loads more slowly in the Singapore branch office than in the United States branch office. The company needs a solution so that the dashboard loads consistently for users in each location. Which solution will meet these requirements in the MOST operationally efficient way?
Options
- ATake a snapshot of the DB instance in us-west-2. Create a new DB instance in ap-southeast-2
- BCreate an RDS read replica in ap-southeast-1 from the primary DB instance in us-west-2.
- CCreate a new DB instance in ap-southeast-1. Use AWS Database Migration Service (AWS DMS)
- DCreate an RDS read replica in us-west-2, where the primary DB instance resides. Create a read
How the community answered
(25 responses)- A8% (2)
- B72% (18)
- C16% (4)
- D4% (1)
Why each option
To resolve slow dashboard loading for users in Singapore connected to an Amazon RDS MySQL database in us-west-2, the most operationally efficient solution is to create an Amazon RDS read replica in the ap-southeast-1 region.
Taking a snapshot and creating a new DB instance in `ap-southeast-2` (a different region from the frontend) does not provide a continuously updated, low-latency read replica for the `ap-southeast-1` frontend.
Creating an Amazon RDS cross-Region read replica in `ap-southeast-1` from the primary DB instance in `us-west-2` allows read traffic from Singapore-based users to be served by a local replica, significantly reducing latency and improving dashboard load times in an operationally efficient manner.
Creating a new DB instance and using AWS DMS for synchronization is a more complex and less operationally efficient solution for read scaling compared to native RDS read replicas.
Creating an RDS read replica in `us-west-2` only helps with read scaling within that region and does not reduce latency for users accessing the application from `ap-southeast-1`.
Concept tested: Cross-region RDS read replicas for read latency
Source: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html
Topics
Community Discussion
No community discussion yet for this question.