1.2 Evaluate Database High Availability and Disaster Recovery Options Given the Requirements PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A company runs a production database on Cloud SQL. They want to be notified before any maintenance event occurs so they can prepare their team. What is the recommended way to receive these notifications?

   • ASet up a Cloud Monitoring alerting policy for the 'cloudsql.googleapis.com/instance/maintenance' metric
   • BCheck the Cloud Console dashboard daily for maintenance notifications
   • CUse the gcloud command to check the maintenance status
   • DSubscribe to the Google Cloud status page RSS feed
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A company runs a critical production database on Cloud SQL. Their application has a maintenance window of 2 AM to 4 AM local time on Sundays, during which they can tolerate a brief database restart. They want to ensure that Google performs maintenance during this window and that they are notified in advance. What should they do?

   • ASet the maintenance window in the Cloud SQL instance settings and configure notification channels in Cloud Monitoring
   • BCreate a Cloud Scheduler job to restart the database every Sunday at 2 AM
   • CContact Google Cloud Support to request a specific maintenance time
   • DUse the maintenance window field in the instance's gcloud command and rely on email notifications from the Cloud Console
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A company runs a Cloud SQL for PostgreSQL instance in europe-west1. They have a disaster recovery requirement to fail over to a different region in the event of a regional outage. What should they do?

   • AUse a read replica in europe-west4 and promote it during a disaster
   • BEnable high availability with a zonal replica in europe-west1
   • CCreate a cross-region replica in europe-west4 and promote it during a disaster
   • DUse automated backups and restore to a new instance in another region
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A media streaming company uses Cloud Spanner for user session data. They have a multi-region configuration with replicas in us-central1 and us-east1. They are experiencing higher than expected costs and want to reduce them without significantly impacting availability or latency for their primary user base in the eastern US. What is the most cost-effective option?

   • ARemove the us-central1 replica and keep only us-east1
   • BChange the configuration to a single-region instance in us-east1 with a zonal replica
   • CSwitch to a regional instance in us-central1 and use a read replica in us-east1
   • DReduce the number of nodes in the us-central1 region
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A global e-commerce company runs a Spanner instance with replicas in three regions: us-central1, europe-west1, and asia-southeast1. Their application is latency-sensitive and users are distributed across North America, Europe, and Asia. They want to minimize write latency for users in each region while maintaining global consistency. What configuration should they use?

   • ACreate three separate single-region Spanner instances and replicate data manually
   • BUse a single regional instance in us-central1 and rely on a CDN for read traffic
   • CConfigure all three regions as read-only replicas and keep a single write region in us-central1
   • DUse multi-region configuration with all three regions as read-write replicas
   Reveal Solution Discussion Select an answer first