Google Professional Cloud Database Engineer Question 72
Single answerGoogle Cloud PlatformYour company is planning to deploy a mission-critical database system and is evaluating options for hosting it. The database must be highly available, require minimal operational overhead, and provide automated backups and scaling. After considering cost, complexity, and performance, which of the following would be the most suitable option?
- A
Host the database on a bare-metal server in your on-premises data center.
- B
Use a self-managed database on Compute Engine instances.
- C
Deploy a Google Cloud-managed database service like Cloud Spanner or Cloud SQL.
- D
Leverage a partner database offering integrated with Google Cloud, such as MongoDB Atlas.
Show answer and explanation
Correct answer: C
Explanation
Google Cloud-managed database services like Cloud Spanner or Cloud SQL are specifically designed to reduce operational overhead while providing features such as high availability, automated backups, and scaling. This makes them the best choice for mission-critical workloads where simplicity and reliability are key. Other options, such as bare-metal servers or self-managed databases, require more manual intervention and effort to meet the same level of functionality.
- A. Incorrect.
Hosting the database on a bare-metal server would require significant operational overhead, such as hardware maintenance, backups, and scaling. This does not align with the requirement for minimal operational overhead.
- B. Incorrect.
Using a self-managed database on Compute Engine involves managing patches, backups, scaling, and high availability yourself, which increases operational complexity and does not meet the requirement for automated backups and scaling.
- C. Correct.
Google Cloud-managed database services like Cloud Spanner or Cloud SQL provide high availability, automated backups, and scaling with minimal operational overhead, making them the most suitable option for the given requirements.
- D. Incorrect.
While partner database offerings like MongoDB Atlas are viable, they may not provide the same level of seamless integration and operational simplicity as Google Cloud-managed databases for this scenario.