Google Professional Cloud Database Engineer Exam - 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

Effie

3 months ago

Naming conventions are crucial, don't overlook them!

upvoted 0 times

...

Chana

3 months ago

Wait, can Dataflow even handle this?

upvoted 0 times

...

Fidelia

4 months ago

Cloning from a template sounds efficient!

upvoted 0 times

...

Sherita

4 months ago

I disagree, using the console is easier for small setups.

upvoted 0 times

...

Gilma

4 months ago

Terraform scripts are the way to go for automation!

upvoted 0 times

...

Nancey

4 months ago

I feel like Dataflow might be overkill for this task, but I can't recall the specifics of when to use it versus Terraform.

upvoted 0 times

...

Arthur

5 months ago

I practiced a similar question where we had to ensure compliance with naming conventions, and I think cloning from a template could help with that.

upvoted 0 times

...

Karol

5 months ago

I'm not entirely sure, but I think using the Google Cloud Console might be too manual for hundreds of instances.

upvoted 0 times

...

Bernardine

5 months ago

I remember we discussed automation in class, and Terraform seemed like a solid choice for managing infrastructure.

upvoted 0 times

...

Hollis

5 months ago

Option D seems like the easiest solution - just clone a template instance. But I'm not sure if that would fully address the need to adhere to the naming conventions and other standards. Might have to dig deeper into the requirements.

upvoted 0 times

...

Judy

5 months ago

Definitely going to go with option B on this one. Terraform scripts will allow me to easily define and provision the instances according to the company standards. Plus, I can version control the scripts for future use.

upvoted 0 times

...

Barney

5 months ago

Hmm, I'm a bit unsure about this one. Creating hundreds of instances manually using the console UI seems like it would be a real pain. Maybe option A with a Dataflow job could be a good approach?

upvoted 0 times

...

Bok

5 months ago

This seems like a classic case of needing to automate the provisioning process. I'd go with option B and set up Terraform scripts to handle the instance creation and configuration.

upvoted 0 times

...

Rosendo

5 months ago

The Response Action element is used to call an APEX class and method, right? I'm pretty confident that's the correct answer, but I'll double-check just to be sure.

upvoted 0 times

...

Edward

5 months ago

I'm a little confused by the options here. Removing ACL logging doesn't seem relevant to enabling BFD. I'll need to review the BFD configuration process to determine the correct steps.

upvoted 0 times

...

Jaime

10 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

10 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

9 months ago

D) Create clones from a template Cloud SQL instance.

upvoted 0 times

...

Frederica

9 months ago

B) Automate instance creation by setting up Terraform scripts.

upvoted 0 times

...

Stephen

10 months ago

A) Automate instance creation by writing a Dataflow job.

upvoted 0 times

...

Barbra

11 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

9 months ago

A) Automate instance creation by writing a Dataflow job.

upvoted 0 times

...

Bambi

9 months ago

D) Create clones from a template Cloud SQL instance.

upvoted 0 times

...

Paola

9 months ago

B) Automate instance creation by setting up Terraform scripts.

upvoted 0 times

...

Jesusita

9 months ago

A) Automate instance creation by writing a Dataflow job.

upvoted 0 times

...

Louann

10 months ago

B) Automate instance creation by setting up Terraform scripts.

upvoted 0 times

...

Theron

10 months ago

A) Automate instance creation by writing a Dataflow job.

upvoted 0 times

...

Deonna

11 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

11 months ago

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

upvoted 0 times

...

Annice

11 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