Examkin

Question

Difficulty: HardSelecting and Designing Storage and Database Resources

A global pharmaceutical enterprise is architecting a mission-critical platform to track international clinical trial supply chains across North America and Europe. The solution must support relational schema enforcement and strong ACID transactional consistency for writes across both continents to satisfy strict regulatory compliance. The workload requires horizontal write scaling to handle unpredictable surges in telemetry log entries without manual database sharding, while continuing to support standard ANSI SQL queries for reporting tools. Which Google Cloud storage service should the lead cloud architect select to meet these requirements?

  1. Cloud Spanner configured with a multi-region instance configuration across North America and Europe.Answer
  2. B
    Cloud SQL for PostgreSQL deployed with regional High Availability and cross-region asynchronous read replicas.
  3. C
    Cloud Storage dual-region bucket using Customer-Supplied Encryption Keys (CSEK) for payload security.
  4. D
    Cloud Bigtable multi-cluster instance relying exclusively on identity IAM policies to restrict exfiltration across perimeters.

Answer

Cloud Spanner configured with a multi-region instance configuration across North America and Europe.
The correct option specifies Cloud Spanner configured across multiple regions. Cloud Spanner is Google Cloud's fully managed, enterprise-grade relational database designed specifically for workloads requiring global multi-region scale, horizontal write scaling, ANSI SQL compliance, and strong ACID transactional consistency.

Step-by-Step Solution

1
Analyze database requirements
Identified core requirements: relational schema, multi-region ACID transactions with strong consistency for writes across continents, horizontal write scaling, and ANSI SQL query support.
These constraints rule out unstructured object storage and databases incapable of cross-region synchronous write transactions.
2
Evaluate relational database options in Google Cloud
Cloud SQL only scales reads via asynchronous replicas across regions and cannot scale writes horizontally or provide multi-region synchronous ACID writes. Cloud Spanner utilizes atomic clocks (TrueTime) to provide global ACID transactions and horizontal write scaling.
Cloud Spanner is the only managed Google Cloud relational service engineered for global, multi-region active-active transactional consistency without manual database sharding.
3
Select optimal service architecture
Recommend Cloud Spanner with a multi-region deployment topology.
Satisfies all transactional consistency, scalability, and query requirements simultaneously.

Key Concept

Multi-Region Relational Storage Selection and Cloud Spanner vs Cloud SQL Architecture
Rate this question

Topics

Selecting and Designing Storage and Database Resources