Google Professional Cloud Database Engineer Question 257
Single answerGoogle Cloud PlatformYour organization frequently provisions Cloud SQL instances for different projects. To streamline the process, you want to automate the provisioning of database instances with predefined configurations such as machine type, storage size, and backup settings. Which approach should you use to achieve this?
- A
Use Deployment Manager to define and deploy a template for Cloud SQL instance creation.
- B
Manually configure and create Cloud SQL instances using the Google Cloud Console for each project.
- C
Use gcloud CLI commands in a script to provision Cloud SQL instances and apply configurations.
- D
Write a custom Python application that uses the Cloud SQL Admin API to create new instances.
Show answer and explanation
Correct answer: A
Explanation
To automate database instance provisioning with predefined configurations, Deployment Manager is the most efficient and scalable solution. It allows you to define declarative templates that can be reused across projects, eliminating the need for repetitive manual or script-based tasks.
- A. Correct.
Correct: Deployment Manager allows you to define reusable templates for infrastructure provisioning, including Cloud SQL instances, automating the process with predefined configurations.
- B. Incorrect.
Incorrect: Manually configuring instances is not automated and doesn't meet the requirement to streamline the provisioning process.
- C. Incorrect.
Incorrect: While gcloud CLI can be scripted, it requires maintaining custom scripts and doesn't provide the reusability and declarative approach of Deployment Manager.
- D. Incorrect.
Incorrect: Writing a custom Python application using the Cloud SQL Admin API is possible but requires significant development effort and maintenance, making it less efficient compared to Deployment Manager.