Topic 1 Question 118
You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest data. You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?
Create a read replica for the Sales Reporting application.
Create two separate databases in the instance, and perform dual writes from the Order Management application.
Use a Cloud SQL federated query for the Sales Reporting application.
Queue up all the requested reports in PubSub, and execute the reports at night.
ユーザの投票
コメント(3)
- 正解だと思う選択肢: A
Read replica is more than enough
👍 4chelbsik2022/12/26 A: Create a read replica for the ***** Sales Reporting application.
👍 2pk3492022/12/24A. B could be done, but would need some application work to make it happen. Eliminate B. Federated queries are queries sent from BigQuery to Cloud SQL or Cloud Spanner with the results returned to BigQuery as a temporary table. So C is wrong. Even if D made sense, running all the reports at night would still impact the Order Management application since it accesses the database 24x7. That leaves A which is the classic solution to offload reads from the primary instance.
👍 1dynamic_dba2023/03/16
シャッフルモード