4.1 Apply Concepts to Implement Scalable and Highly Available Databases in Google Cloud. PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   Which tool is commonly used to automate the provisioning of Google Cloud database instances by defining infrastructure as code?

   • ATerraform
   • Bgcloud CLI
   • CCloud Shell
   • DCloud Console
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   A database engineer wants to be notified when a Cloud SQL read replica's replication lag exceeds a certain threshold. What should they configure?

   • AA Cloud Function that checks replication lag periodically.
   • BA log-based metric in Cloud Logging to track replication lag.
   • CA Cloud Scheduler job to send notifications when lag is high.
   • DAn alerting policy in Cloud Monitoring based on the replication lag metric.
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   A database team wants to validate that their Cloud SQL HA configuration will fail over successfully during a zone outage. Which action directly tests this without affecting production traffic?

   • APerform a planned failover using the Cloud SQL API or console to switch the primary to the standby zone.
   • BDelete the primary instance and observe if the standby takes over automatically.
   • CStop the primary instance and wait for the standby to promote itself.
   • DCreate a read replica and promote it to primary to simulate failover.
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   Which Google Cloud service is used to set up monitoring and alerting for database instances, such as tracking CPU utilization and replication lag?

   • ACloud Logging
   • BCloud Monitoring
   • CCloud Audit Logs
   • DCloud Shell
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   Which activity is part of a disaster recovery (DR) drill for a database?

   • AMonitoring CPU utilization of the primary instance.
   • BRestoring a database from a backup to a separate instance and validating data integrity.
   • CAdding a new read replica to handle increased read traffic.
   • DUpdating the database schema to add a new column.
   Reveal Solution Discussion Select an answer first