Google Cloud Professional Cloud Database Engineer — Question 62

You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?

Answer options

• A. Use Cloud Scheduler and Cloud Functions to run the daily export.
• B. Create a streaming Datatlow job to export the table.
• C. Set up Cloud Composer, and create a task to export the table daily.
• D. Run the cron job on a Compute Engine instance to continue the export.

Correct answer: A

Explanation

Using Cloud Scheduler and Cloud Functions (Option A) is the best choice as it automates the export process without the need for managing server resources, thus minimizing costs and operational overhead. Option B, a streaming Dataflow job, is more complex and not necessary for a simple export. Option C requires more setup and management overhead with Cloud Composer, while Option D involves maintaining a Compute Engine instance, which is not cost-effective for this task.