nerdexam
Google

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #102

Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent dat

The correct answer is A. Set Terraform deletion_protection to true.. https://cloud.google.com/docs/terraform/best-practices-for-terraform#stateful-resources

Managing Cloud SQL Infrastructure

Question

Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped. What should you do?

Options

  • ASet Terraform deletion_protection to true.
  • BRerun terraform apply.
  • CCreate a read replica.
  • DUse point-in-time-recovery (PITR) to recover the database.

How the community answered

(24 responses)
  • A
    75% (18)
  • B
    13% (3)
  • C
    4% (1)
  • D
    8% (2)

Explanation

https://cloud.google.com/docs/terraform/best-practices-for-terraform#stateful-resources

Topics

#Terraform#Cloud SQL#Deletion Protection#Infrastructure as Code

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice