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

Questions 11–15

1. 11application · medium

   A database engineer is responsible for a Cloud SQL for SQL Server instance that supports a line-of-business application. The team has defined an SLO that the database must be available 99.9% of the time. The engineer needs to be alerted if the instance becomes unavailable. What should the engineer configure?

   • AConfigure a Cloud Function that periodically queries the database and sends an email if the query fails.
   • BSet up a Cloud Logging sink that sends all database logs to BigQuery for analysis.
   • CCreate an uptime check in Cloud Monitoring that probes the instance's public IP address and set an alert on failure.
   • DUse Cloud Monitoring to create a dashboard showing CPU utilization and query latency.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A company runs a Cloud SQL for SQL Server instance. The database engineer needs to automate the task of exporting the results of a specific query to a Cloud Storage bucket every day. The export should contain only the query results, not the entire database. What should the engineer do?

   • ASchedule a Cloud SQL backup and then copy the backup file to Cloud Storage.
   • BUse a Cloud Scheduler job to run 'gcloud sql export sql' with a query parameter.
   • CUse the Cloud SQL Admin API to export the entire database to Cloud Storage.
   • DCreate a Cloud Function that connects to the database, runs the query, and writes the results to Cloud Storage.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   A Cloud Scheduler job is configured to invoke a Cloud Function that exports a database. What is the primary role of Cloud Scheduler in this automation?

   • ATo trigger the export at the scheduled time
   • BTo monitor the export's success
   • CTo store the exported data
   • DTo execute the export logic
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   A team wants to export a Cloud SQL database to Cloud Storage every night at 2:00 AM without manual intervention. Which combination of Google Cloud services can automate this?

   • ABigQuery and Cloud Scheduler
   • BCloud Functions and Cloud Pub/Sub
   • CCloud Scheduler and Cloud Functions
   • DCloud Run and Cloud Storage
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   A database administrator needs to improve query performance on a large Cloud SQL for PostgreSQL table by reducing index fragmentation. Which maintenance operation directly addresses this?

   • ARebuilding the index
   • BExporting the table data
   • CUpdating table statistics
   • DVacuuming the table
   Reveal Solution Discussion Select an answer first