Google Professional Cloud Database Engineer Question 74
Select 3Google Cloud PlatformYour company is planning to migrate its on-premises database infrastructure to Google Cloud. The team is debating between using a self-managed database on Compute Engine, a Google-managed database like Cloud SQL, or a partner database offering like MongoDB Atlas. Which of the following are characteristics of Google-managed database services that differentiate them from self-managed databases?
- A
Automated backups and updates are handled by Google.
- B
You have full control over the operating system and database version.
- C
Scaling is managed automatically based on workload needs.
- D
Requires manual patching and database configuration by the user.
- E
Integrates natively with other Google Cloud services such as BigQuery and IAM.
Show answer and explanation
Correct answers: A, C, E
Explanation
Google-managed database services simplify database management by automating tasks such as backups, updates, and scaling, while also providing native integrations with other Google Cloud services. In contrast, self-managed databases require users to handle these operational responsibilities manually, offering more control but at the expense of increased complexity and operational overhead.
- A. Correct.
Correct: Google-managed database services like Cloud SQL or Cloud Spanner handle tasks such as backups, updates, and patching automatically, reducing operational overhead.
- B. Incorrect.
Incorrect: In a Google-managed database service, the operating system and database version are controlled by Google, not the user. Full control over these aspects is a characteristic of self-managed databases.
- C. Correct.
Correct: Google-managed databases include features like automatic scaling to handle workload demands, which is not available in self-managed databases.
- D. Incorrect.
Incorrect: Manual patching and configuration are responsibilities of the user in a self-managed database, not in Google-managed services.
- E. Correct.
Correct: Google-managed database services integrate seamlessly with other Google Cloud services like BigQuery and IAM, making them easier to use in a cloud-native ecosystem.