You use Python scripts to generate weekly SQL reports to assess the state of your...

Vendor: Google
Product: Professional-Cloud-Database-Engineer
Update on: Jul 31, 2025
Questions: 141

Google Professional-Cloud-Database-Engineer Question Answer

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?

Create a VM in Compute Engine, and run a cron job.

Create a Cloud Composer instance, and create a directed acyclic graph (DAG).

Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.

Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.