PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #196
You are performing daily exports of native BAK files from Cloud SOL for SOL Server to Cloud Storage buckets by using gcloud sql export bak command at 6:00AM. You want to automate this routine using…
The correct answer is B. Create a Cloud Run function to export with a Pub/Sub trigger. Create a Cloud Scheduler job to. The most reliable and managed way to automate daily exports is to use Cloud Scheduler to trigger a Pub/Sub topic, which then invokes a Cloud Run function that runs the gcloud sql export bak command. This eliminates the need for manual cron jobs or unmanaged scripts, providing a…
Question
You are performing daily exports of native BAK files from Cloud SOL for SOL Server to Cloud Storage buckets by using gcloud sql export bak command at 6:00AM. You want to automate this routine using managed Google Cloud components so you can focus on other critical tasks of keeping your database healthy and performant. What should you do-
Options
- AEnable retained backups for the instance.
- BCreate a Cloud Run function to export with a Pub/Sub trigger. Create a Cloud Scheduler job to
- CImplement automated backups using the console and set the default retention to 7 days.
- DCreate a cron job to export and configure Pub/Sub as the target. Set a recurring schedule of 0 6 * *
How the community answered
(28 responses)- A4% (1)
- B79% (22)
- C11% (3)
- D7% (2)
Explanation
The most reliable and managed way to automate daily exports is to use Cloud Scheduler to trigger a Pub/Sub topic, which then invokes a Cloud Run function that runs the gcloud sql export bak command. This eliminates the need for manual cron jobs or unmanaged scripts, providing a scalable, serverless, and fully managed automation solution.
Topics
Community Discussion
No community discussion yet for this question.