Google Professional Cloud Database Engineer Question 244
Select 2Google Cloud PlatformYour company has a global e-commerce application running on Google Cloud, backed by a Cloud SQL database. To ensure high availability and low latency for customers in different regions, you are tasked with setting up multi-regional replication for the database. Which of the following steps are required to configure multi-regional replication for Cloud SQL?
- A
Enable binary logging on the primary instance.
- B
Create a read replica in the desired secondary region.
- C
Configure a replica instance to use the Cloud SQL Proxy.
- D
Set up a managed instance group for the primary database.
- E
Ensure the primary instance has sufficient storage for write-ahead logs.
Show answer and explanation
Correct answers: A, B
Explanation
To set up multi-regional replication for Cloud SQL, binary logging must be enabled on the primary instance, as it facilitates the replication process. Additionally, a read replica must be created in the secondary region to serve regional traffic. Other options, such as using the Cloud SQL Proxy or setting up managed instance groups, are unrelated to the replication setup process.
- A. Correct.
Enabling binary logging is required because Cloud SQL uses binary logging to replicate data from the primary instance to the replica instance.
- B. Correct.
Creating a read replica in the desired region is a necessary step to achieve multi-regional replication in Cloud SQL.
- C. Incorrect.
Configuring a replica instance to use the Cloud SQL Proxy is not required for multi-regional replication. The proxy is typically used for secure connections, not replication setup.
- D. Incorrect.
A managed instance group is unrelated to Cloud SQL. These are used for Compute Engine instances, not databases.
- E. Incorrect.
While write-ahead logs (WALs) are important for database recovery, they are not directly related to setting up multi-regional replication in Cloud SQL.