GoogleGoogle
PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #70
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #70: Real Exam Question with Answer & Explanation
The correct answer is D: Use the Query Insights dashboard to identify high execution times.. See the full explanation below for the reasoning.
Optimizing database performance
Question
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?
Options
- AView Cloud SQL operations to view historical query information.
- BWhite a Logs Explorer query to identify database queries with high execution times.
- CReview application logs to identify database calls.
- DUse the Query Insights dashboard to identify high execution times.
Topics
#Cloud SQL for PostgreSQL#Query Performance#Monitoring#Query Insights
Community Discussion
No community discussion yet for this question.