Câu 51: Google Cloud Professional Cloud Database Engineer

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?

1. A. Create a read replica for the Sales Reporting application. — đáp án hiện tại
2. B. Create two separate databases in the instance, and perform dual writes from the Order Management application.
3. C. Use a Cloud SQL federated query for the Sales Reporting application.
4. D. Queue up all the requested reports in PubSub, and execute the reports at night.