Topic 1 Question 59

Professional Cloud Database Engineer

Topic 1 Question 59
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?
- Issue a gcloud sql instances patch command to increase the number of vCPUs.
- Update a MySQL database flag to increase the number of vCPUs.
- Issue a gcloud compute instances update command to increase the number of vCPUs.
- Back up the database, create an instance with additional vCPUs, and restore the database.
ユーザの投票
コメント(4)
- 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
  
  👍 2
  pk3492022/12/24
- 正解だと思う選択肢: A
  https://cloud.google.com/sdk/gcloud/reference/sql/instances/patch#:~:text=existing%20authorized%20networks.-,%2D%2Dcpu,-%3DCPU
  
  👍 2
  chelbsik2022/12/25
- 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.
  
  👍 2
  dynamic_dba2023/03/12
シャッフルモード

ユーザの投票

コメント(4)