ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam
Go to Exam

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 Hide Answer
Suggested Answer: A 🗳️
by pk349 at Dec. 25, 2022, 12:11 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
887ad17
3 months ago
Selected Answer: A
gcloud sql instances patch [INSTANCE_NAME] --cpu=[NUMBER_OF_VCPUS]
upvoted 1 times
...
Pime13
6 months ago
Selected Answer: A
https://cloud.google.com/sdk/gcloud/reference/sql/instances/patch
upvoted 1 times
...
juliorevk
1 year ago
Selected Answer: A
https://cloud.google.com/sdk/gcloud/reference/sql/instances/patch
upvoted 1 times
...
dynamic_dba
1 year, 7 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, 7 months ago
Selected Answer: A
"gcloud sql instances patch" --> updates the settings of a Cloud SQL instance
upvoted 1 times
...
chelbsik
1 year, 10 months 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
1 year, 10 months 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago