Google Professional Cloud Database Engineer Question 49
Single answerGoogle Cloud PlatformYour organization is planning to deploy a global e-commerce platform using Google Cloud. The platform will require a highly available, scalable database solution that can automatically distribute data across multiple regions while ensuring low latency for users. Additionally, the database must support strong security features such as encryption at rest and in transit. Which solution best meets these requirements?
- A
Cloud Spanner with multi-region configuration and IAM permissions
- B
Cloud SQL with a read replica in multiple regions and a custom SSL/TLS setup
- C
BigQuery with regional datasets and row-level security
- D
Firestore in Datastore mode with manual backups and custom encryption keys
Show answer and explanation
Correct answer: A
Explanation
Cloud Spanner is the ideal choice for a global e-commerce platform requiring a highly available, scalable, and secure database. Its multi-region configuration ensures low latency and high availability, while built-in features like encryption and IAM integration simplify security management. Other options either lack true multi-region capabilities, are designed for different use cases, or require additional manual configuration for security.
- A. Correct.
Cloud Spanner is a globally distributed, horizontally scalable database that supports multi-region configurations with low-latency reads and writes. It also provides encryption at rest and in transit, and integrates with IAM for fine-grained access control.
- B. Incorrect.
Cloud SQL supports read replicas for scalability, but it does not provide true multi-region writes or automatic data distribution across regions. Additionally, setting up SSL/TLS manually involves more overhead than using a managed solution like Spanner.
- C. Incorrect.
BigQuery is optimized for analytical workloads, not transactional workloads like those required by an e-commerce platform. While it supports security features such as row-level security, it is not designed for low-latency global distribution.
- D. Incorrect.
Firestore in Datastore mode is a NoSQL database that can scale well, but it does not support strong multi-region configurations for low-latency global access. Manual backups and custom encryption keys add complexity compared to managed solutions.