Google Professional Cloud Database Engineer Question 245
Select 3Google Cloud PlatformYou are managing a Cloud Spanner database for a global e-commerce platform. The platform requires high availability, low-latency reads, and disaster recovery capabilities across multiple regions. You decide to set up multi-regional replication for the database. Which of the following configurations do you need to implement to achieve this?
- A
Configure a multi-regional instance with at least one read-write region and two read-only regions.
- B
Configure high availability by enabling 3 replicas in a single region.
- C
Assign a leader region for the multi-regional instance.
- D
Use Google Cloud's automatic replication management to distribute data across regions.
- E
Enable manual backups to ensure data integrity in case of failure.
Show answer and explanation
Correct answers: A, C, D
Explanation
To set up multi-regional replication for a Cloud Spanner database, you must configure a multi-regional instance with at least one read-write region and one or more read-only regions. A leader region must also be specified for write operations. Google Cloud Spanner automatically handles data replication across the specified regions, ensuring high availability and disaster recovery. Manual backups, while important for data integrity, are not directly related to setting up multi-regional replication.
- A. Correct.
Correct. A multi-regional instance in Cloud Spanner must have at least one read-write region and one or more read-only regions for high availability and disaster recovery.
- B. Incorrect.
Incorrect. Configuring 3 replicas in a single region does not provide multi-regional replication, as it limits redundancy and availability to a single region.
- C. Correct.
Correct. Assigning a leader region is necessary for managing write operations and ensuring low-latency writes in a multi-regional setup.
- D. Correct.
Correct. Google Cloud automatically handles data replication across regions in a multi-regional setup, ensuring high availability and consistency.
- E. Incorrect.
Incorrect. While manual backups are useful for data recovery, they are not a requirement for setting up multi-regional replication, as data replication is automatically managed by Cloud Spanner.