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

Questions 6–10

1. 6expert · medium

   A financial trading platform uses Cloud Spanner with a multi-region configuration in us-central1 and us-east1. They have a regulatory requirement for data residency in the United States. They are considering adding a replica in europe-west1 to improve latency for European users. What is the primary concern?

   • AThe potential for increased write latency due to the additional region
   • BThe violation of the data residency requirement
   • CThe increased complexity of managing a multi-region configuration
   • DThe additional cost of the europe-west1 replica
   Reveal Solution Discussion Select an answer first
2. 7expert · medium

   A company runs a global application on Cloud Spanner with a multi-region configuration in us-central1, us-east1, and europe-west1. They are experiencing higher than expected costs and want to reduce them. They have analyzed their traffic and found that 80% of their users are in the US. What is the most cost-effective change they can make?

   • ARemove the europe-west1 region and keep only us-central1 and us-east1
   • BSwitch to a single-region configuration in us-central1
   • CReduce the number of nodes in the europe-west1 region
   • DUse a regional instance in us-east1 and a read replica in us-central1
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   A team is planning to perform a database upgrade that requires a brief downtime. The application has a strict availability requirement, and users must be notified in advance. Which notification mechanism is most appropriate for informing users about the upcoming maintenance?

   • APost a message on the company's internal wiki page
   • BSend an email to all registered users one week before the maintenance
   • CDo not notify users because the downtime is brief
   • DWait until the maintenance is complete and then send a notification
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   A financial services company must deploy a database that stores customer data. Regulatory requirements mandate that all data remain within a specific country. The application is used by customers worldwide and must remain available even if an entire cloud region fails. Which deployment strategy best meets these requirements?

   • ARegional deployment with synchronous replication across zones
   • BZonal deployment with synchronous replication within the zone
   • CMulti-regional deployment within the same country
   • DMulti-regional deployment across different countries
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A company runs a Cloud SQL for MySQL instance. They want to be notified via email when a maintenance event is scheduled for their instance. What should they configure?

   • AA Cloud Function that sends an email when triggered by a maintenance event
   • BA Cloud Monitoring alerting policy with an email notification channel
   • CA Cloud Pub/Sub topic with a push subscription to an email service
   • DA Cloud Scheduler job that checks the maintenance status and sends an email
   Reveal Solution Discussion Select an answer first