Google Professional Cloud Database Engineer Question 71
Single answerGoogle Cloud PlatformYour organization is building a web application that requires a PostgreSQL database. The team wants to minimize operational overhead, ensure high availability, and focus on application development rather than managing the database infrastructure. Which of the following options would best meet your organization's requirements?
- A
Deploy PostgreSQL on Compute Engine using a custom VM setup.
- B
Use Cloud SQL for PostgreSQL, a Google-managed database service.
- C
Set up PostgreSQL on a Kubernetes cluster using a StatefulSet.
- D
Host PostgreSQL on bare-metal servers in your on-premises data center.
Show answer and explanation
Correct answer: B
Explanation
For teams looking to minimize operational overhead while ensuring high availability, a fully managed database service like Cloud SQL for PostgreSQL is the optimal choice. It abstracts away the complexities of database management, including backups, scaling, and failover, allowing the team to focus on application development instead of infrastructure management. Other options, such as self-managed solutions on Compute Engine, Kubernetes, or bare-metal servers, require the team to handle the database's operational aspects, making them less suitable for this scenario.
- A. Incorrect.
Deploying PostgreSQL on Compute Engine provides flexibility but requires significant operational effort, such as managing backups, patches, high availability, and scaling. This does not align with the goal of minimizing operational overhead.
- B. Correct.
Cloud SQL for PostgreSQL is a fully managed Google Cloud service that automates backups, scaling, and high availability. It allows the team to focus on application development rather than database management, making it the best fit for the given scenario.
- C. Incorrect.
Running PostgreSQL on a Kubernetes cluster using a StatefulSet requires the team to manage the database deployment, scaling, and failover, which increases operational complexity compared to a fully managed service.
- D. Incorrect.
Hosting PostgreSQL on bare-metal servers in an on-premises data center involves significant operational overhead, such as hardware maintenance, backups, and high availability configurations. This does not align with the team's goal of minimizing operational effort.