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?

Exam-Like

Create a read replica for the Sales Reporting application.

52.8%

Create two separate databases in the instance, and perform dual writes from the Order Management application.

16.7%

Use a Cloud SQL federated query for the Sales Reporting application.

19.4%

Queue up all the requested reports in PubSub, and execute the reports at night.

11.1%

Google Professional Cloud Database Engineer