Google Cloud Professional Cloud Database Engineer — Question 89

You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?

Answer options

• A. Shut down and restart each application.
• B. Write a utility to scan database query logs.
• C. Write a utility to scan application logs.
• D. Use query tags to add application-centric database monitoring.

Correct answer: D

Explanation

Using query tags allows for application-centric monitoring, making it easier to identify which application is responsible for inefficient queries. The other options, like shutting down applications or writing utilities to scan logs, do not directly align with Google’s best practices and may not efficiently resolve the issue.