PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #55
You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #55. The question stem and answer options stay visible for context.
Question
You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead. What should you do?
Options
- ACreate a VM in Compute Engine, and run a cron job.
- BCreate a Cloud Composer instance, and create a directed acyclic graph (DAG).
- CCreate a Cloud Function, and call the Cloud Function using Cloud Scheduler.
- DCreate a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.
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.