Free Google Professional Cloud Database Engineer Actual Exam Questions - Question 7 Discussion
daily export of a table, which was previously a cron job running on the database server, continues.
You want the solution to minimize cost and operations overhead. What should you do?
It’s A. Using Cloud Scheduler with Cloud Functions is super lightweight and avoids the cost and hassle of managing a VM or Composer environment. Plus, it fits well for simple scheduled exports.
Maybe D could work since it keeps the existing cron job logic intact without extra refactoring, but it’s definitely more expensive and needs more maintenance than serverless options.
I agree that running the cron job on a Compute Engine instance (D) adds overhead and cost since you’d have to manage the VM. Options B and C seem too complex just for a daily export. Could the simplicity of A really beat the others?
Probably A. Cloud Scheduler plus Cloud Functions seems like a low-cost, managed way to replace a cron job without much overhead. The others feel heavier or more expensive.