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

Questions 1–5

1. 1application · medium

   Your team uses Terraform to manage infrastructure. You need to create a Cloud SQL for PostgreSQL instance with a read replica in a different region. You want to ensure that the replica is created after the primary instance and that the configuration is repeatable. What should you do?

   • ADefine both the primary and replica in the same Terraform configuration file, using a 'depends_on' attribute to ensure the replica is created after the primary.
   • BCreate the primary instance using Terraform and then use the gcloud command to create the replica.
   • CUse a script to create the primary and then the replica, but do not store the script in version control.
   • DCreate the primary instance using Terraform, then manually create the replica in the Cloud Console.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   Your organization runs a critical application on Cloud SQL for MySQL with high availability enabled. As part of your disaster recovery plan, you need to regularly test failover to ensure the application can tolerate a regional outage. You also need to verify that the failover process meets your recovery time objective (RTO) of 10 minutes. What should you do?

   • ARestore a backup to a new instance and verify the application can connect to it.
   • BPromote a read replica to primary and redirect application traffic to it.
   • CCreate a Cloud Monitoring alert for instance availability and assume the failover works if no alerts fire.
   • DUse the Cloud SQL API to trigger a manual failover and measure the time it takes for the standby to become primary.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which Google Cloud database service provides built-in multi-region replication with automatic failover and strong consistency across regions?

   • ACloud Spanner
   • BCloud SQL
   • CFirestore
   • DBigtable
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which Google Cloud database service is designed to provide regional redundancy and automatic failover as a core feature, without requiring manual configuration of standby instances?

   • ACloud SQL
   • BBigtable
   • CCloud Spanner
   • DFirestore
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   In Cloud SQL, what is the process of converting a read replica into a standalone primary instance called?

   • AReplicating the replica
   • BFailing over the replica
   • CRestoring the replica
   • DPromoting the replica
   Reveal Solution Discussion Select an answer first