Free PROFESSIONAL-CLOUD-DATABASE-ENGINEER Web TestEngine Demo

Q17 Single choice

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?

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.

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Web TestEngine demo