Google Professional Cloud Database Engineer Question 46
Select 3Google Cloud PlatformYou are tasked with designing a database architecture for an e-commerce platform that experiences unpredictable traffic spikes during sales events. The database must be highly available, scalable, and secure. Which combination of strategies would best address these requirements?
- A
Use Cloud Spanner with multi-region configuration for high availability and scalability.
- B
Implement VPC Service Controls to secure the database by restricting access.
- C
Enable Cloud SQL with read replicas to scale read operations during traffic spikes.
- D
Store sensitive customer data in plaintext for simplicity and faster queries.
- E
Use a single Cloud SQL instance with no failover configured to reduce costs.
Show answer and explanation
Correct answers: A, B, C
Explanation
To design a scalable, highly available, and secure database, it is essential to choose solutions that ensure performance under unpredictable traffic, protect sensitive data, and provide redundancy. Cloud Spanner with multi-region configuration offers robust scalability and availability, while VPC Service Controls secure the database. Cloud SQL with read replicas is useful for scaling read-heavy workloads. Avoiding practices like storing sensitive data in plaintext and using single-instance setups with no failover ensures the design aligns with best practices.
- A. Correct.
Using Cloud Spanner with multi-region configuration ensures horizontal scalability and high availability, making it suitable for unpredictable traffic spikes.
- B. Correct.
VPC Service Controls add a layer of security by restricting access to the database, which is critical for protecting sensitive e-commerce data.
- C. Correct.
Cloud SQL with read replicas can offload read operations during traffic spikes, improving performance and scalability.
- D. Incorrect.
Storing sensitive customer data in plaintext is a major security risk and violates best practices for data protection.
- E. Incorrect.
Using a single Cloud SQL instance with no failover compromises availability and scalability, especially during traffic spikes or failures.