Google Professional Cloud Database Engineer Question 47
Select 3Google Cloud PlatformYour team is designing a solution for an e-commerce application that needs a database capable of handling sudden, unpredictable spikes in traffic during sales events. The database should be highly available across multiple regions, support automatic scaling, and ensure data is encrypted both in transit and at rest. Which combination of Google Cloud database services and configurations would best meet these requirements?
- A
Use Cloud Spanner configured with multi-region replication and customer-managed encryption keys (CMEK).
- B
Use Cloud SQL with a single-zone configuration and enable automated backups.
- C
Use Bigtable with replication across multiple zones and enforce encryption in transit using TLS.
- D
Use Firestore in Native mode with multi-region deployment and default encryption settings.
- E
Use Memorystore for Redis in a single-zone configuration to handle traffic spikes and ensure high availability.
Show answer and explanation
Correct answers: A, C, D
Explanation
The scenario requires a database that can handle high scalability, ensure high availability across multiple regions, and provide robust encryption. Cloud Spanner, Bigtable, and Firestore are designed to meet these requirements when properly configured. Cloud SQL and Memorystore do not fulfill the high availability and scalability requirements in this scenario.
- A. Correct.
Cloud Spanner is a globally distributed, horizontally scalable, and highly available database. Configuring multi-region replication ensures high availability, and using CMEK allows for strong encryption both in transit and at rest.
- B. Incorrect.
Cloud SQL with a single-zone configuration does not meet the high availability requirement, as it is limited to one zone and cannot handle region-level failures.
- C. Correct.
Bigtable is a highly scalable, low-latency database service. Configuring it with replication across multiple zones ensures high availability, and enforcing TLS ensures data is encrypted in transit.
- D. Correct.
Firestore in Native mode supports multi-region deployment for high availability and scalability. Its default encryption settings provide strong encryption at rest and in transit, which meets the security requirement.
- E. Incorrect.
Memorystore for Redis is a good option for caching but is not designed to be a primary database for highly available, multi-region use cases. A single-zone configuration does not meet the high availability requirement.