MENU
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?
Suggested Answer: D
Get Premium Professional Cloud Database Engineer Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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.
36 comments · newest first
EF
Effie
11 months ago
Naming conventions are crucial, don't overlook them!
CH
Chana
11 months ago
Wait, can Dataflow even handle this?
FI
Fidelia
11 months ago
Cloning from a template sounds efficient!
SH
Sherita
11 months ago
I disagree, using the console is easier for small setups.
GI
Gilma
12 months ago
Terraform scripts are the way to go for automation!
NA
Nancey
12 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.
AR
Arthur
1 year 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.
KA
Karol
1 year ago
I'm not entirely sure, but I think using the Google Cloud Console might be too manual for hundreds of instances.
BE
Bernardine
1 year ago
I remember we discussed automation in class, and Terraform seemed like a solid choice for managing infrastructure.
HO
Hollis
1 year 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.
JU
Judy
1 year 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.
BA
Barney
1 year 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?
BO
Bok
1 year 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.
RO
Rosendo
1 year 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.
ED
Edward
1 year 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.
JA
Jaime
1 year ago
Yeah, no way I'm doing that by hand. Might as well just give me a keyboard and tell me to start typing.
HE
Helene
1 year 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!
LE
Leatha
1 year ago
D) Create clones from a template Cloud SQL instance.
FR
Frederica
1 year ago
B) Automate instance creation by setting up Terraform scripts.
ST
Stephen
1 year ago
A) Automate instance creation by writing a Dataflow job.
BA
Barbra
2 years ago
But what if we need to tweak some specific settings for each team? Wouldn't using a template instance be more flexible?
KI
Kip
1 year ago
A) Automate instance creation by writing a Dataflow job.
BA
Bambi
1 year ago
D) Create clones from a template Cloud SQL instance.
PA
Paola
1 year ago
B) Automate instance creation by setting up Terraform scripts.
JE
Jesusita
1 year ago
A) Automate instance creation by writing a Dataflow job.
LO
Louann
1 year ago
B) Automate instance creation by setting up Terraform scripts.
TH
Theron
1 year ago
A) Automate instance creation by writing a Dataflow job.
DE
Deonna
2 years 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.
CA
Carmen
2 years ago
I prefer creating clones from a template Cloud SQL instance for faster provisioning.
AN
Annice
2 years 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.
AJ
Aja
1 year ago
Creating clones could also work, but Terraform might be more efficient in the long run.
HE
Heike
1 year ago
D) Create clones from a template Cloud SQL instance.
IR
Irving
1 year ago
That's a good idea. Terraform will definitely help us maintain consistency.
JE
Jenelle
2 years ago
B) Automate instance creation by setting up Terraform scripts.
AR
Armando
2 years ago
I agree with Omega, Terraform scripts will ensure consistency and adherence to company standards.
OM
Omega
2 years ago
I think we should automate instance creation with Terraform scripts.