Google Cloud Professional Cloud Database Engineer — Question 67

You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?

Answer options

• A. View Cloud SQL operations to view historical query information.
• B. White a Logs Explorer query to identify database queries with high execution times.
• C. Review application logs to identify database calls.
• D. Use the Query Insights dashboard to identify high execution times.

Correct answer: D

Explanation

The correct answer is D because the Query Insights dashboard provides specialized tools for monitoring and analyzing query performance within Cloud SQL, making it ideal for identifying high execution times. Option A does not provide detailed execution insights, while option B may not capture all necessary data regarding query performance, and option C focuses on application-level interactions rather than database query specifics.