Google Cloud Professional Cloud Database Engineer — Question 49

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?

Answer options

• 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.

Correct answer: A

Explanation

Creating a read replica for the Sales Reporting application allows it to access the latest data without placing additional load on the primary database used by the Order Management application, thus maintaining its performance. The other options either complicate the architecture unnecessarily or do not effectively isolate the load from the Sales Reporting application, which could still impact the Order Management application's performance.