Answer-first summary for fast verification
Answer: Create a read replica for the Sales Reporting application.
To ensure that the performance of the Order Management application is not affected by the Sales Reporting application, the best approach is to create a read replica for the Sales Reporting application. This allows the Sales Reporting application to read from the replica, which is updated asynchronously from the primary database, thus not impacting the write performance of the Order Management application. Option B is not ideal because creating two separate databases would require dual writes, which could complicate data consistency and increase write overhead. Option C, using a Cloud SQL federated query, is not suitable as it does not address the performance impact on the primary database. Option D, queuing reports in PubSub and executing them at night, would not provide the Sales Reporting application with the latest data as required. Therefore, the correct answer is A.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you prevent the Sales Reporting application from impacting the performance of the Order Management application when both interact with the same Cloud SQL for MySQL database, given that Order Management requires constant read-write access while Sales Reporting is read-only, and both need the latest data?
A
Create a read replica for the Sales Reporting application.
B
Create two separate databases in the instance, and perform dual writes from the Order Management application.
C
Use a Cloud SQL federated query for the Sales Reporting application.
D
Queue up all the requested reports in PubSub, and execute the reports at night.
No comments yet.