Google Exam Professional Cloud Database Engineer Topic 8 Question 37 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 37
Topic #: 8

[All Professional Cloud Database Engineer Questions]

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?

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.

Show Suggested Answer

Suggested Answer: D

BMS is the only Google database service which supports Oracle aside from GCVE. It allows you to use all native Oracle features including RAC. Since GCVE isn't mentioned, it has to be D - Bare Metal Solution.

by Carlee at Jul 10, 2024, 05:35 PM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jaime

1 months ago

Yeah, no way I'm doing that by hand. Might as well just give me a keyboard and tell me to start typing.

upvoted 0 times

...

Helene

1 months ago

Haha, I can just see the IT team trying to create hundreds of instances in the Console. That's going to be a nightmare!

upvoted 0 times

Leatha

4 days ago

D) Create clones from a template Cloud SQL instance.

upvoted 0 times

...

Frederica

6 days ago

B) Automate instance creation by setting up Terraform scripts.

upvoted 0 times

...

Stephen

1 months ago

A) Automate instance creation by writing a Dataflow job.

upvoted 0 times

...

Barbra

2 months ago

But what if we need to tweak some specific settings for each team? Wouldn't using a template instance be more flexible?

upvoted 0 times

Kip

3 hours ago

A) Automate instance creation by writing a Dataflow job.

upvoted 0 times

...

Bambi

4 days ago

D) Create clones from a template Cloud SQL instance.

upvoted 0 times

...

Paola

9 days ago

B) Automate instance creation by setting up Terraform scripts.

upvoted 0 times

...

Jesusita

13 days ago

A) Automate instance creation by writing a Dataflow job.

upvoted 0 times

...

Louann

1 months ago

B) Automate instance creation by setting up Terraform scripts.

upvoted 0 times

...

Theron

2 months ago

A) Automate instance creation by writing a Dataflow job.

upvoted 0 times

...

Deonna

2 months ago

I was thinking the same thing. Terraform scripts would be perfect for this use case. Way easier than manually creating each instance in the Console.

upvoted 0 times

...

Carmen

2 months ago

I prefer creating clones from a template Cloud SQL instance for faster provisioning.

upvoted 0 times

...

Annice

2 months ago

Automating instance creation with Terraform seems like the way to go. It'll help us manage the infrastructure as code and ensure consistency across all the instances.

upvoted 0 times