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

Questions 6–10

1. 6application · medium

   Your company has a Cloud SQL for MySQL instance in us-central1. You need to provide low-latency reads for users in europe-west1. You also want to ensure that the data is durable in case of a regional outage. What should you do?

   • AEnable high availability on the primary instance in us-central1.
   • BCreate a cross-region read replica in europe-west1 and configure the application to use it for read traffic.
   • CCreate a second primary instance in europe-west1 and use synchronous replication.
   • DUse Cloud Spanner with a multi-region configuration.
   Reveal Solution Discussion Select an answer first
2. 7expert · hard

   Your company runs a global e-commerce platform using Cloud Spanner with a multi-region configuration (nam3). The compliance team requires a disaster recovery drill that validates recovery from a regional outage. You need to test the failover to a different region without impacting production traffic. What is the best approach?

   • ACreate a separate Cloud Spanner instance in a different region and run a disaster recovery simulation against it.
   • BPerform a failover test by stopping the primary region and observing the automatic failover to the secondary region.
   • CUse the Cloud Spanner API to simulate a regional failure and verify that the instance remains available.
   • DConduct a table-level restore from a backup in a different region and verify data integrity.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   A database engineer needs to deploy a Cloud SQL for PostgreSQL instance with automatic failover to a standby in a different zone within the same region. Which configuration satisfies this requirement?

   • ACreate a read replica in a different region and promote it manually during an outage.
   • BEnable high availability (HA) configuration when creating the instance, which provisions a synchronous standby in another zone.
   • CDeploy the instance on a single zone and rely on Cloud SQL's automatic restart to recover from failures.
   • DConfigure a cross-region replica using Cloud SQL's built-in replication and enable automatic failover.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   A database engineer wants to offload read traffic from a Cloud SQL primary instance to a read replica. What is the primary purpose of creating a read replica?

   • ATo scale horizontally by serving read queries from the replica.
   • BTo provide automatic failover in case the primary fails.
   • CTo ensure data durability by storing a second copy of the data.
   • DTo increase write capacity by distributing writes across multiple instances.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   A company needs to set up cross-region replication for Cloud SQL to support disaster recovery and low-latency reads in another region. Which feature should they use?

   • APoint-in-time recovery
   • BCross-region read replicas
   • CAutomatic failover to a standby
   • DHigh availability configuration
   Reveal Solution Discussion Select an answer first