Google Professional Cloud Database Engineer Question 203
Select 3Google Cloud PlatformYou are managing a PostgreSQL database on Cloud SQL and need to schedule regular daily exports of the database to a Cloud Storage bucket for backup purposes. Which of the following steps should you take to automate this process?
- A
Create a Cloud Scheduler job with a cron schedule and configure it to trigger a Cloud Function.
- B
Write a Cloud Function that uses the Cloud SQL Admin API to trigger an export operation to a Cloud Storage bucket.
- C
Grant the Cloud Scheduler and Cloud Function service accounts the 'Cloud SQL Admin' and 'Storage Admin' roles.
- D
Use the gcloud CLI to manually export the database to Cloud Storage every day.
- E
Enable the automated backup feature in the Cloud SQL instance settings.
Show answer and explanation
Correct answers: A, B, C
Explanation
To schedule daily database exports, you need to automate the process using tools like Cloud Scheduler and Cloud Functions. Cloud Scheduler defines the schedule, while a Cloud Function can handle the export logic using the Cloud SQL Admin API. Appropriate IAM roles must also be assigned to ensure permissions are in place. Manual exports and automated backups do not meet the requirement for scheduled daily exports to a Cloud Storage bucket.
- A. Correct.
Correct: Cloud Scheduler is used to define a schedule (e.g., cron job) to trigger a task like database export. It can call a Cloud Function to execute the export operation.
- B. Correct.
Correct: A Cloud Function can use the Cloud SQL Admin API to programmatically export the database to Cloud Storage as part of an automated workflow.
- C. Correct.
Correct: To enable these operations, appropriate IAM roles (e.g., 'Cloud SQL Admin' for database export and 'Storage Admin' for writing to the bucket) must be granted to the service accounts involved.
- D. Incorrect.
Incorrect: While the gcloud CLI can be used for manual exports, it does not automate the process or align with the requirement to schedule daily exports.
- E. Incorrect.
Incorrect: Enabling automated backup only creates backups within Cloud SQL and does not export the data to a Cloud Storage bucket.