Question

Difficulty: MediumProvisioning Storage and Database Systems

A platform engineering team is establishing automated infrastructure provisioning routines for a regional order processing service on Google Cloud. The architecture requires a managed relational database instance and an object storage bucket for audit logs. Corporate security policies demand that all storage encryption keys remain under central organization management in Cloud KMS without developers handling raw key material, and infrastructure automation must prevent concurrent state modification and accidental state file corruption. Which TWO provisioning configurations should the engineering team implement? (Select TWO.)

  1. Configure the Terraform remote backend to use a Google Cloud Storage bucket with Object Versioning enabled for managing state files.Answer
  2. Provision the Cloud SQL instance using a Customer-Managed Encryption Key (CMEK) hosted in Cloud Key Management Service (KMS).Answer
  3. C
    Maintain the Terraform `.tfstate` files on a local shared developer filesystem to bypass cloud storage API authentication requirements.
  4. D
    Configure Customer-Supplied Encryption Keys (CSEK) by supplying 256-bit AES encryption key strings directly inside the Terraform configuration files.

Answer

The team should configure the Terraform remote backend to use a Google Cloud Storage bucket with Object Versioning enabled and provision the Cloud SQL instance using a Customer-Managed Encryption Key (CMEK) in Cloud KMS.
Configuring a Cloud Storage remote backend with Object Versioning ensures Terraform state files are locked during concurrent execution and backed up against state corruption. Provisioning Cloud SQL with Customer-Managed Encryption Keys (CMEK) in Cloud KMS satisfies regulatory key-governance requirements without introducing raw key management risk.

Step-by-Step Solution

1
Establish secure state storage for Infrastructure as Code
Configured a GCS backend with Object Versioning enabled.
Prevents race conditions through native GCS object locking and preserves historical state revisions for rollback in case of corruption.
2
Implement compliance-aligned database encryption
Provisioned Cloud SQL instance with CMEK referencing a key ring in Cloud KMS.
Allows central governance over key rotation and access policies while keeping cryptographic key handling within managed Google Cloud services.

Key Concept

Provisioning secure cloud database and storage resources via IaC requires robust remote state locking and compliance-driven KMS key integration.
Rate this question