PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #196
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #196: Real Exam Question with Answer & Explanation
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 s
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 * *
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.