Question

Difficulty: EasyRelease Management and Deployment Strategies

An engineering team is configuring an automated CI/CD release pipeline for a web service deployed on Google Cloud Run using Terraform for infrastructure provisioning. The application relies on Cloud SQL for persistent data storage. Which TWO deployment and infrastructure management practices should the team implement to ensure release reliability and zero-downtime deployments?

  1. Perform database schema changes using multi-phase, backward-compatible updates before deploying new application code.Answer
  2. Configure Cloud Storage with object versioning as a remote backend for storing Terraform state files.Answer
  3. C
    Execute destructive database schema migrations concurrently with deploying the new Cloud Run revision.
  4. D
    Store Terraform state files locally within the CI/CD pipeline runner local file system.
  5. E
    Assign the primitive Owner IAM role to the deployment service account to streamline pipeline permissions.

Answer

The team must perform database schema changes using multi-phase, backward-compatible updates before deploying new application code, and configure Cloud Storage with object versioning as a remote backend for storing Terraform state files.
Safe release management requires that database changes are backward-compatible so that both old and new application instances can run concurrently without errors during traffic migration. Additionally, reliable Infrastructure as Code deployments depend on centralized state management with locking and versioning enabled in Cloud Storage.

Step-by-Step Solution

1
Ensure Database Backward Compatibility
Database schemas support both the active version and the new application version simultaneously.
Prevents live traffic errors and broken queries during canary traffic shifting or blue-green rollouts.
2
Configure Centralized IaC Remote Backend
Terraform state is locked during updates and maintained with full version history.
Prevents state corruption and concurrency conflicts across CI/CD execution runs.

Key Concept

Zero-downtime release management and Infrastructure as Code state management
Rate this question