Exam Professional Cloud Database Engineer topic 1 question 154 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 154
Topic #: 1

[All Professional Cloud Database Engineer Questions]

You are designing the backup and recovery strategy of a Cloud SQL for MySQL database that serves a write heavy application. You need to be able to restore the database to any point in time within the past five days while minimizing the performance impact of database backups. What should you do?

A. Enable automatic backup and point in time recovery. Configure the backup window during periods of low database traffic. Set backup and transaction log retention to at least five days.
B. Schedule hourly on-demand backups and enable point in time recovery. Delete any delete backups that were taken over five days ago.
C. Schedule a database export job to run every hour from a read replica instance. Retain the export dumps for at least five days.
D. Schedule a database export job to run every hour. Use serverless export. Retain the export dumps for at least five days.

Show Suggested Answer

Suggested Answer: A 🗳️

by Sai_Vignesh at Aug. 7, 2025, 3:17 a.m.

Comments

Submit Cancel

Sai_Vignesh

1 week, 1 day ago

Selected Answer: B

Locked in on B. The other choices are clearly distractors.

upvoted 1 times

...