Examkin

Question

Difficulty: Very hardProvisioning Storage and Database Systems

An enterprise is implementing a automated cloud infrastructure deployment pipeline on Google Cloud for a global transactional database and operational storage architecture. The technical requirements specify a relational database engine capable of handling multi-region transactions with external consistency across continents. Furthermore, the Infrastructure as Code (IaC) deployment pipeline using Terraform must guarantee concurrency safety and state recovery against corrupted or conflicting parallel executions. Which TWO architecture and provisioning strategies should be implemented to satisfy these requirements?

  1. Provision a Cloud Spanner multi-region instance configuration to support globally distributed relational transactions with strong consistency.Answer
  2. Configure the Terraform backend using a Google Cloud Storage bucket with object versioning enabled and native state locking.Answer
  3. C
    Provision a multi-region Cloud SQL for PostgreSQL instance with Customer-Supplied Encryption Keys (CSEK) to support global multi-master write operations.
  4. D
    Store the Terraform state files inside an unversioned local directory within the CI/CD worker container image to maintain high-speed pipeline state access.

Answer

The correct architecture requires provisioning a Cloud Spanner multi-region instance for global relational ACID transactions and configuring a Cloud Storage backend with object versioning and state locking for Terraform state management.
Provisioning Cloud Spanner satisfies the requirement for multi-region relational database transactions with external consistency. Additionally, using Cloud Storage with versioning and state locking for the Terraform remote backend ensures safe concurrent deployment pipeline execution without state corruption.

Step-by-Step Solution

1
Analyze the database requirements for global multi-region transactional processing.
Identify that Cloud Spanner is required due to its native support for multi-region, strongly consistent relational transactions, whereas Cloud SQL only supports regional primary instances with read replicas.
Cloud SQL cannot support multi-region write transactions across continents.
2
Analyze Infrastructure as Code state management requirements for CI/CD safety.
Select Google Cloud Storage as the remote backend for Terraform, enabling object versioning and locking.
Remote state locking prevents concurrent pipeline runs from corrupting state, while object versioning allows rolling back state in case of corruption.

Key Concept

Multi-region database provisioning and IaC remote state locking
Estimated Time:3m 0s
Rate this question

Topics

Provisioning Storage and Database Systems

More questions from this topic