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 n

Question

Options

• AAutomate instance creation by writing a Dataflow job.
• BAutomate instance creation by setting up Terraform scripts.
• CCreate the instances using the Google Cloud Console UI.
• DCreate clones from a template Cloud SQL instance.

• A
  5% (2)
• B
  83% (33)
• C
  3% (1)
• D
  10% (4)

Explanation

Terraform is an Infrastructure as Code (IaC) tool that allows you to define Cloud SQL instance configurations - including naming conventions, database flags, labels/tags, and other settings - in reusable, version-controlled scripts. Running these scripts guarantees that every instance is created identically according to company standards, is auditable, and can be reproduced or updated consistently at scale. Option A (Dataflow) is a data processing pipeline service and cannot provision infrastructure. Option C (Google Cloud Console UI) is manual, does not scale to hundreds of instances, and is highly error-prone for enforcing consistent standards. Option D (cloning from a template) does not enforce naming conventions and lacks the flexibility and governance that IaC provides.

No community discussion yet for this question.