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 ma
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #196. The question stem and answer options stay visible for context.
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 * *
Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.