Question
You have configured a database in the headquarters office located in Houston, Texas. Your company has office in major cities across Canada and the United States. Users in Eastern Canada complain about slow query access to the database, while Texas users enjoy fast performance. What should you do?
Group of answer choices
Create a foreign key
Place a writeable replica in Eastern Canada
Place a read replica in Eastern Canada
Create an index
Group of answer choices
Create a foreign key
Place a writeable replica in Eastern Canada
Place a read replica in Eastern Canada
Create an index
Answers
GPT-4o mini
In this scenario, where users in Eastern Canada are experiencing slow query access to a database hosted in Houston, Texas, the best solution from the given options would be to:
**Place a read replica in Eastern Canada.**
This approach would help improve query access performance for users in Eastern Canada by reducing latency. The read replica would allow users to query data from a location closer to them, thus alleviating the load on the primary database and speeding up response times.
Placing a writable replica would not be necessary unless you need to allow write operations in that region, which isn't indicated in the scenario. Creating a foreign key or an index would not address the latency issues for the remote users.
**Place a read replica in Eastern Canada.**
This approach would help improve query access performance for users in Eastern Canada by reducing latency. The read replica would allow users to query data from a location closer to them, thus alleviating the load on the primary database and speeding up response times.
Placing a writable replica would not be necessary unless you need to allow write operations in that region, which isn't indicated in the scenario. Creating a foreign key or an index would not address the latency issues for the remote users.