Question 112 of 139
Single answerYou 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?
✓ACreate a read replica for the Sales Reporting application.
BCreate two separate databases in the instance, and perform dual writes from the Order Management application.
CUse a Cloud SQL federated query for the Sales Reporting application.
DQueue up all the requested reports in PubSub, and execute the reports at night.
✓
Correct Answer: A
Create a read replica for the Sales Reporting application.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.