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

Questions 1–5

1. 1expert · medium

   A logistics company uses Cloud Spanner for tracking shipments. They have a multi-region configuration with replicas in us-central1, us-east1, and us-west1. They are experiencing a regional outage in us-central1 and need to ensure their application remains available. What is the impact on their application?

   • AThe application will experience downtime until the us-central1 region is restored
   • BThe application will experience increased latency because all traffic will be routed to us-east1
   • CThe application will experience downtime because us-central1 is the primary region
   • DThe application will continue to operate with no impact because Spanner automatically fails over to another region
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   A startup is deploying a new application and must choose a database deployment strategy. The application is latency-sensitive and serves users in a single metropolitan area. The team has no strict data residency requirements beyond the country level. Which deployment strategy best balances low latency and cost while providing resilience against a single-zone failure?

   • ARegional deployment with asynchronous replication across regions
   • BRegional deployment with synchronous replication across zones
   • CMulti-regional deployment with active-active replication
   • DZonal deployment with no replication
   Reveal Solution Discussion Select an answer first
4. 3expert · medium

   A company runs a critical application on Cloud Spanner with a multi-region configuration in us-central1 and us-east1. They have a requirement to maintain data residency in the US. They are considering adding a replica in us-west1 to improve latency for users on the west coast. What is the primary benefit of this change?

   • AIt simplifies the management of the Spanner instance
   • BIt improves write latency for users in the western US
   • CIt reduces the cost of the Spanner instance
   • DIt improves availability by adding a third region
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A company runs a Cloud Spanner instance with a single-region configuration in us-central1. They want to improve availability and are considering a multi-region configuration. What is the primary benefit of moving to a multi-region configuration?

   • AIt provides lower latency for all users globally
   • BIt provides automatic failover to a standby instance in another region
   • CIt provides higher availability by replicating data across multiple regions
   • DIt provides point-in-time recovery for disaster recovery
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A retail company uses Cloud SQL for PostgreSQL for their inventory system. They have a maintenance window set for Sundays from 2 AM to 4 AM. They recently started a 24/7 flash sale and want to ensure no maintenance occurs during the sale. What should they do?

   • AContact Google Cloud Support to request a maintenance deferral
   • BDisable the maintenance window during the flash sale
   • CTake a manual backup before the sale and restore it if maintenance occurs
   • DChange the maintenance window to a time after the flash sale ends
   Reveal Solution Discussion Select an answer first