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…

Question

Options

• AShut down and restart each application.
• BWrite a utility to scan database query logs.
• CWrite a utility to scan application logs.
• DUse query tags to add application-centric database monitoring.

• A
  11% (3)
• B
  4% (1)
• C
  14% (4)
• D
  71% (20)

Explanation

Query tags allow applications to embed metadata (such as application name, team, or version) directly into SQL statements as structured comments (e.g., using the sqlcommenter format). Cloud SQL Insights can then surface this metadata, enabling you to filter and attribute inefficient queries to a specific application without any manual log scanning. This is the Google-recommended approach for application-centric database observability. Option A (shutting down and restarting each application) is disruptive to production and is not a diagnostic technique. Option B (scanning database query logs) and Option C (scanning application logs) are manual, time-consuming, and error-prone approaches that Google-recommended tooling is designed to replace.

No community discussion yet for this question.