Google Professional Cloud Database Engineer Question 202
Single answerGoogle Cloud PlatformYour organization requires daily exports of a Cloud SQL database for archival purposes. The export files should be stored in a Google Cloud Storage bucket. You need to schedule these exports to occur automatically at 2 AM every day. Which approach should you take to meet this requirement?
- A
Use Cloud Scheduler to trigger a Cloud Function that calls the Cloud SQL Admin API to export the database.
- B
Configure the Cloud SQL instance to automatically export the database to a Cloud Storage bucket using a built-in schedule in the Cloud SQL settings.
- C
Use a cron job on a Compute Engine VM to call the Cloud SQL Admin API and export the database.
- D
Manually export the database each day using the Google Cloud Console.
Show answer and explanation
Correct answer: A
Explanation
Cloud Scheduler is a fully managed cron job service that integrates seamlessly with Cloud Functions and the Cloud SQL Admin API. By using Cloud Scheduler, you can automate the export process and specify the exact time for the operation, such as 2 AM daily. This solution is more reliable and easier to maintain compared to using a Compute Engine VM or performing manual exports.
- A. Correct.
This is the correct approach. Cloud Scheduler can be used to trigger a Cloud Function that automates the export process using the Cloud SQL Admin API. This approach allows you to schedule the export at a specific time, such as 2 AM daily.
- B. Incorrect.
This option is incorrect because Cloud SQL does not have a built-in feature for scheduling automatic exports. Exports must be managed externally using tools like Cloud Scheduler and Cloud Functions.
- C. Incorrect.
This option is technically possible but is not the best practice. Managing cron jobs on a Compute Engine VM introduces additional complexity and maintenance overhead compared to using Cloud Scheduler and Cloud Functions.
- D. Incorrect.
This option is incorrect because it involves manual intervention, which does not meet the requirement for automation.