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

Questions 26–29

1. 26foundation · medium

   What is the purpose of setting up alerts for database errors?

   • ATo proactively detect and respond to failures
   • BTo automatically fix the errors
   • CTo reduce the number of errors
   • DTo replace the need for manual monitoring
   Reveal Solution Discussion Select an answer first
2. 27foundation · medium

   Which Google Cloud service is used to collect and visualize database vitals such as CPU and memory utilization?

   • ACloud Source Repositories
   • BCloud Identity
   • CCloud Monitoring
   • DCloud Deployment Manager
   Reveal Solution Discussion Select an answer first
4. 28application · medium

   A team manages a Cloud Spanner instance. They notice a specific query is slow and suspect a missing index. They want to confirm this and get a recommendation. What should they do?

   • AEnable audit logging and review the logs for the query.
   • BUse the Spanner Query Insights to view the query plan and check for a full table scan.
   • CIncrease the number of nodes in the Spanner instance.
   • DSet up an alert on CPU utilization for the Spanner instance.
   Reveal Solution Discussion Select an answer first
5. 29application · medium

   A company runs a Cloud SQL for PostgreSQL instance. They want to proactively monitor the instance's health by tracking key vitals like CPU, memory, and disk usage, and be notified when thresholds are breached. What should they configure?

   • ACloud Audit Logs to track administrative actions.
   • BCloud Logging to capture all SQL query logs.
   • CCloud Scheduler to run a script that checks vitals periodically.
   • DCloud Monitoring dashboards and alerting policies on the instance's metrics.
   Reveal Solution Discussion Select an answer first