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

Questions 11–15

1. 11expert · hard

   Your organization uses Terraform to manage Cloud SQL instances. You need to enable high availability on an existing instance without recreating it. The instance is currently in the 'RUNNABLE' state. What should you do?

   • AUse the gcloud command to enable high availability, then update the Terraform state manually.
   • BDelete the instance and recreate it with 'availability_type' set to 'REGIONAL'.
   • CModify the Terraform configuration to set 'availability_type' to 'REGIONAL' and apply the change.
   • DCreate a new instance with high availability and migrate the data.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   What is a key benefit of using Infrastructure as Code (IaC) to provision database instances?

   • AIt provides a graphical interface for managing databases.
   • BIt eliminates the need for backups and monitoring.
   • CIt enables consistent and repeatable deployments across environments.
   • DIt automatically scales database instances based on load.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   Your company is deploying a global application that requires strong consistency and low write latency for users in North America and Europe. You need to ensure that data is replicated across regions for durability and availability. Which Google Cloud database service should you choose?

   • ACloud SQL for MySQL with failover replicas
   • BCloud Spanner with a multi-region configuration
   • CAlloyDB for PostgreSQL with cross-region replication
   • DCloud SQL for PostgreSQL with cross-region read replicas
   Reveal Solution Discussion Select an answer first
5. 14expert · hard

   Your organization uses Terraform to manage a Cloud SQL for PostgreSQL instance. You need to add a read replica and ensure that the replica is created in the same region as the primary. You also want to avoid downtime during the update. What should you do?

   • AModify the existing primary instance resource to include replica settings.
   • BAdd a 'google_sql_database_instance' resource for the replica with 'master_instance_name' set to the primary's name and apply the Terraform configuration.
   • CDelete the primary instance and recreate it with a replica in the same configuration.
   • DCreate the replica using the gcloud command and then import it into Terraform state.
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   Your application uses Cloud SQL for MySQL with a read replica to handle reporting queries. You need to ensure that the replica is being used effectively and that it is not causing performance issues on the primary. What should you monitor?

   • AMonitor the replica lag and the primary's CPU utilization.
   • BMonitor the replica's CPU utilization and the primary's disk usage.
   • CMonitor the replica's network traffic and the primary's connections.
   • DMonitor the replica's disk usage and the primary's memory usage.
   Reveal Solution Discussion Select an answer first