Exam Professional Cloud Database Engineer topic 1 question 59 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 59
Topic #: 1

[All Professional Cloud Database Engineer Questions]

Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?

A. Issue a gcloud sql instances patch command to increase the number of vCPUs.
B. Update a MySQL database flag to increase the number of vCPUs.
C. Issue a gcloud compute instances update command to increase the number of vCPUs.
D. Back up the database, create an instance with additional vCPUs, and restore the database.

Show Suggested Answer

Suggested Answer: A 🗳️

by pk349 at Dec. 25, 2022, 12:11 a.m.

Comments

Submit Cancel

887ad17

5 months, 2 weeks ago

Selected Answer: A

gcloud sql instances patch [INSTANCE_NAME] --cpu=[NUMBER_OF_VCPUS]

upvoted 1 times

...

Pime13

8 months, 2 weeks ago

Selected Answer: A

https://cloud.google.com/sdk/gcloud/reference/sql/instances/patch

upvoted 1 times

...

juliorevk

1 year, 3 months ago

Selected Answer: A

https://cloud.google.com/sdk/gcloud/reference/sql/instances/patch

upvoted 1 times

...

dynamic_dba

1 year, 10 months ago

A. D would not represent minimal interruption or effort. B would not change the number of vCPUs available to the instance as a whole. Option C is for GCE VMs, not Cloud SQL.

upvoted 4 times

...

Nirca

1 year, 10 months ago

Selected Answer: A

"gcloud sql instances patch" --> updates the settings of a Cloud SQL instance

upvoted 1 times

...

chelbsik

2 years ago

Selected Answer: A

https://cloud.google.com/sdk/gcloud/reference/sql/instances/patch#:~:text=existing%20authorized%20networks.-,%2D%2Dcpu,-%3DCPU

upvoted 2 times

...

pk349

2 years ago

A: Issue a gcloud sql instances *** patch command to increase the number of vCPUs. Cores Y 1 to 96 (must be either 1 or an even number) Partial for shared vCPU gcloud sql instances patch INSTANCE [--activation-policy=ACTIVATION_POLICY] [--active-directory-domain=ACTIVE_DIRECTORY_DOMAIN] [--[no-]assign-ip] [--async] [--audit-bucket-path=AUDIT_BUCKET_PATH] [--audit-retention-interval=AUDIT_RETENTION_INTERVAL] [--audit-upload-interval=AUDIT_UPLOAD_INTERVAL] [--availability-type=AVAILABILITY_TYPE] [--clear-password-policy] [--connector-enforcement=CONNECTOR_ENFORCEMENT] [--cpu=CPU] [--database-version

upvoted 2 times

...