2.2 Configure Database Monitoring and Troubleshooting Options PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 4)

Questions 16–20

1. 16foundation · medium

   Which database feature or tool provides recommendations for indexes that could improve query performance by analyzing query plans?

   • AIndex recommendations from query plan analysis
   • BFirewall rules
   • CBackup retention policies
   • DConnection pooling settings
   Reveal Solution Discussion Select an answer first
2. 17expert · hard

   A company runs a Cloud SQL for PostgreSQL instance. Users report slow performance during peak hours. Metrics show high CPU and memory usage, and Query Insights reveals a specific query with high execution time. The query performs a full table scan on a large table. The team needs to resolve the contention. What should they do first?

   • ASet up an alert on CPU usage to notify when it exceeds 80%.
   • BEnable audit logging to track who is running the slow query.
   • CAdd an index on the columns used in the WHERE clause of the slow query.
   • DIncrease the instance's memory to reduce disk I/O.
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A company uses Cloud Spanner and is approaching its instance's CPU utilization quota. They want to monitor quota usage and be alerted before hitting the limit to avoid service disruption. What should they do?

   • ASet up a Cloud Function to scale the instance automatically.
   • BCreate a Cloud Monitoring alert on the CPU utilization metric with a threshold below the quota limit.
   • CEnable audit logging to track all queries.
   • DUse Cloud Scheduler to periodically check the quota via the API.
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A company runs a Cloud SQL for MySQL instance. They want to be alerted when the instance's disk usage exceeds 80% to plan for storage expansion before issues occur. What should they configure?

   • AA Cloud Monitoring alerting policy on the disk utilization metric.
   • BA Cloud Audit Log to track who created tables.
   • CA Cloud Logging sink to export all logs to BigQuery.
   • DA Cloud Function that runs every hour to check disk usage.
   Reveal Solution Discussion Select an answer first
6. 20foundation · medium

   What action should be taken when a database is consistently approaching its resource quota limit?

   • AIgnore the usage until it fails
   • BRequest a quota increase
   • CRestart the database instance
   • DDisable audit logging
   Reveal Solution Discussion Select an answer first