Answer-first summary for fast verification
Answer: Use Cloud Scheduler and Cloud Functions to run the daily export.
To ensure the daily export of a table from Cloud SQL with minimal cost and operations overhead, the best approach is to use Cloud Scheduler and Cloud Functions. Cloud Scheduler is a fully managed cron job service that allows you to schedule virtually any job, including invoking Cloud Functions. Cloud Functions is a serverless execution environment that scales automatically and only charges you when the function is running. This combination minimizes both cost and operational overhead by eliminating the need to manage any infrastructure. Option B, creating a streaming Datatlow job, is not suitable for a daily export as it is designed for continuous data processing. Option C, setting up Cloud Composer, introduces unnecessary complexity and cost for a simple daily export task. Option D, running the cron job on a Compute Engine instance, would incur higher costs and operational overhead compared to the serverless options provided by Cloud Scheduler and Cloud Functions.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you maintain the daily export of a table after migrating an on-premises MySQL database to Cloud SQL, while minimizing cost and operational overhead, if the export was previously handled by a cron job on the database server?
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.
No comments yet.