Google Professional Cloud Database Engineer Question 188
Single answerGoogle Cloud PlatformYour company runs a PostgreSQL database on Google Cloud, and you need to automate routine maintenance tasks like backups, vacuuming, and performance monitoring. Which solution would best help you achieve this with minimal manual intervention?
- A
Use Cloud SQL's built-in automated backups, maintenance windows, and query insights.
- B
Manually schedule cron jobs to perform backups and run maintenance scripts on the database.
- C
Set up a Cloud Build pipeline to trigger database maintenance tasks using custom scripts.
- D
Use Firebase Realtime Database for automated database maintenance tasks.
Show answer and explanation
Correct answer: A
Explanation
Cloud SQL is a fully managed database service provided by Google Cloud that includes features like automated backups, maintenance windows, and integrated Query Insights. These features enable users to automate routine database management tasks, making it the best solution for this scenario.
- A. Correct.
This is the correct answer. Cloud SQL provides built-in automation features like automated backups, maintenance windows, and Query Insights. These features are specifically designed to reduce the need for manual intervention in database management tasks.
- B. Incorrect.
This approach requires significant manual configuration and oversight, which goes against the goal of automation and minimal manual intervention.
- C. Incorrect.
While Cloud Build can trigger tasks, this approach is overly complex for routine database maintenance and is not designed for managing database-specific tasks like backups and vacuuming.
- D. Incorrect.
Firebase Realtime Database is not a relational database like PostgreSQL, and it does not provide features for automating tasks such as backups or vacuuming.