ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam
Go to Exam

Exam Professional Cloud Database Engineer topic 1 question 130 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 130
Topic #: 1
[All Professional Cloud Database Engineer Questions]

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?

  • A. Set Terraform deletion_protection to true.
  • B. Rerun terraform apply.
  • C. Create a read replica.
  • D. Use point-in-time-recovery (PITR) to recover the database.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by dynamic_dba at March 28, 2023, 1:34 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
dynamic_dba
Highly Voted 1 year, 7 months ago
A. It makes sense that a Terraform problem would use a Terra form solution. From Google's documentation, "For stateful resources, such as databases, ensure that deletion protection is enabled. The syntax is: lifecycle { prevent_destroy = true } https://cloud.google.com/docs/terraform/best-practices-for-terraform#stateful-resources
upvoted 9 times
...
Pime13
Most Recent 5 months, 3 weeks ago
Selected Answer: A
https://cloud.google.com/docs/terraform/best-practices-for-terraform#stateful-resources
upvoted 1 times
...
DPonly
1 year, 1 month ago
Selected Answer: A
For stateful resources, such as databases, ensure that deletion protection is enabled.
upvoted 1 times
...
dedotes
1 year, 3 months ago
Selected Answer: A
agreed with dynamic_dba
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago