Google Cloud Professional Cloud Database Engineer — Question 80

You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?

Answer options

• A. Automate instance creation by writing a Dataflow job.
• B. Automate instance creation by setting up Terraform scripts.
• C. Create the instances using the Google Cloud Console UI.
• D. Create clones from a template Cloud SQL instance.

Correct answer: B

Explanation

The correct answer is B, as Terraform allows for Infrastructure as Code, enabling the automation of instance creation while ensuring compliance with company standards. Option A, using Dataflow, is more suited for data processing tasks rather than provisioning instances. Option C, using the Google Cloud Console UI, is manual and not scalable for hundreds of instances. Option D involves cloning, which may not adhere to specific naming conventions or tags required for multiple instances.