Examkin

Question

Difficulty: Very hardSelecting and Designing Storage and Database Resources

An enterprise e-commerce platform is refactoring its data storage architecture on Google Cloud to support a global expansion across North America and Europe. The new architecture must satisfy two distinct workload requirements:

1. A core transactional order-processing database requiring relational schema support, multi-region active-active write capabilities across continents, sub-10 millisecond latencies, and strict global ACID compliance.
2. A centralized audit logging repository requiring tamper-proof, immutable WORM (write once, read many) storage to satisfy strict regulatory compliance rules for 7 years.

Which TWO architecture decisions should you include in your storage and database design to satisfy these requirements? (Select TWO answers.)

  1. Provision a multi-region Cloud Spanner instance configuration to host the transactional order-processing database.Answer
  2. Configure Cloud Storage buckets with a Retention Policy and enforce Bucket Lock for storing immutable audit logs.Answer
  3. C
    Deploy a multi-region Cloud SQL for PostgreSQL instance configured with active-active primary nodes across US and Europe for order-processing transactions.
  4. D
    Require Customer-Supplied Encryption Keys (CSEK) managed on local key servers to satisfy Cloud KMS centralized key governance for audit logs.

Answer

Selecting a multi-region Cloud Spanner instance for globally distributed relational ACID transactions and configuring Cloud Storage buckets with locked Retention Policies (Bucket Lock) for immutable WORM compliance logging.
Provisioning Cloud Spanner with a multi-region configuration provides horizontally scalable relational storage capable of executing active-active transactional writes across global regions while guaranteeing external consistency (ACID). Furthermore, implementing a Cloud Storage Retention Policy with Bucket Lock guarantees WORM compliance by permanently preventing object modification or deletion prior to retention expiry.

Step-by-Step Solution

1
Analyze database requirements for the transactional order-processing engine.
Identified the need for relational schema, multi-region active-active writes, and global ACID consistency.
Cloud SQL only supports single-region primary nodes with cross-region read replicas, whereas Cloud Spanner is designed specifically for globally distributed relational transactions with multi-region write availability.
2
Analyze compliance storage requirements for raw audit logs.
Identified the need for long-term immutable object storage enforcing WORM compliance.
Cloud Storage Bucket Lock locks a bucket retention policy so that no user, including project owners and administrators, can delete or overwrite objects until the retention timer expires.

Key Concept

Selecting Cloud Spanner for global multi-region relational ACID workloads and Cloud Storage Bucket Lock for WORM compliance.
Rate this question

Topics

Selecting and Designing Storage and Database Resources