Google Professional Cloud Database Engineer Question 73
Single answerGoogle Cloud PlatformYour company is planning to migrate its critical workload to Google Cloud. The workload requires high availability, minimal operational overhead, automated backups, and built-in scaling capabilities for unpredictable traffic spikes. Which database solution is the most suitable for your use case?
- A
Deploy a self-managed MySQL database on Compute Engine using custom configurations.
- B
Use a Google Cloud SQL managed database instance with automated backups and vertical scaling.
- C
Set up a bare-metal database infrastructure and configure high availability manually.
- D
Leverage partner database offerings within Google Cloud Marketplace for more flexibility.
Show answer and explanation
Correct answer: B
Explanation
The use case specifies the need for a managed solution with minimal operational overhead, high availability, automated backups, and built-in scaling. Google Cloud SQL, as a fully managed database service, fulfills these requirements by handling operational tasks like backups, scaling, and availability automatically. In contrast, self-managed or bare-metal solutions require significant manual effort, and partner offerings may not fully address the stated requirements without additional configuration.
- A. Incorrect.
While a self-managed MySQL database on Compute Engine offers flexibility, it requires significant operational overhead, including configuring backups, scaling, and high availability manually. This doesn't align with the need for minimal operational overhead and built-in scaling.
- B. Correct.
Google Cloud SQL is a fully managed database service that automates backups, provides high availability configurations, and includes built-in scaling. It directly addresses the needs for minimal operational overhead, high availability, and scalability.
- C. Incorrect.
Bare-metal infrastructure requires manual setup and management for high availability and scalability, which increases operational overhead. This option does not align with the requirement for minimal operational burden.
- D. Incorrect.
Partner database offerings provide flexibility but may require additional setup and configuration depending on the database chosen. They do not guarantee minimal operational overhead or built-in scaling out of the box.