2.5 Automate Common Database Tasks PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 1)

Questions 1–5

1. 1application · medium

   A database engineer manages a Cloud SQL for MySQL instance that has been running for months. Query performance has degraded, and the engineer suspects index fragmentation. The instance is in a maintenance window that allows brief downtime. What should the engineer do to rebuild indexes with minimal manual effort?

   • AUse the Cloud SQL 'Restart' button to force index rebuilds automatically.
   • BRun 'ANALYZE TABLE' to update statistics and rebuild indexes.
   • CRun 'OPTIMIZE TABLE' statements on the relevant tables during the maintenance window.
   • DCreate a new index on each table to replace the fragmented ones.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A company uses Cloud SQL for PostgreSQL for a production application. The database engineer needs to plan for a minor version upgrade. The team wants to test the upgrade before applying it to production. What should the engineer do?

   • ACreate a clone of the production instance, apply the upgrade to the clone, and run tests.
   • BApply the upgrade directly to production and rely on rollback procedures.
   • CExport the database, import it into a local PostgreSQL instance, and test there.
   • DUse a read replica to test the upgrade by promoting it.
   Reveal Solution Discussion Select an answer first
4. 3expert · hard

   A database engineer manages a Cloud SQL for SQL Server instance. The team has an SLO that the database must be available 99.95% of the time. The engineer needs to perform index maintenance on a large table. The maintenance must not cause any downtime. What should the engineer do?

   • ARun 'ALTER INDEX ... REBUILD' on the table.
   • BDrop and recreate the indexes.
   • CUse the Cloud SQL Console to rebuild indexes.
   • DRun 'ALTER INDEX ... REORGANIZE' on the table.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   A team needs to be notified when a Cloud SQL instance's availability drops below 99.9% over a 30-day period. Which Google Cloud service should be used to set up this alert?

   • ACloud Scheduler
   • BCloud Monitoring
   • CCloud Logging
   • DCloud Functions
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A database engineer manages a Cloud SQL for PostgreSQL instance. The team has an SLO that query latency should be under 100 ms for 95% of requests. The engineer needs to be alerted when this SLO is at risk. What should the engineer configure?

   • ASet up a Cloud Function that runs a query every minute and measures the response time.
   • BCreate a Cloud Monitoring alert on the 'cloudsql.googleapis.com/database/postgresql/query_count' metric with a threshold of 95%.
   • CCreate a Cloud Logging alert on any log entry containing 'slow query'.
   • DUse Cloud Monitoring to create an SLO based on the 'cloudsql.googleapis.com/database/postgresql/query_latency' metric and set an alert on the SLO burn rate.
   Reveal Solution Discussion Select an answer first