PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #90: Real Exam Question with Answer & Explanation

Question

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?

Options

• ACreate a read replica for the Sales Reporting application.
• BCreate two separate databases in the instance, and perform dual writes from the Order
• 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.

No community discussion yet for this question.