Examkin

Soru

Zorluk: OrtaDeploying and Configuring Managed Database Instances

A cloud engineer is deploying a new Cloud SQL for MySQL database instance named app-db to support a production application. The deployment requirements specify that the instance must provide regional high availability with automatic failover and must be accessible only via Private IP within the existing Virtual Private Cloud (VPC) network named corp-vpc, without any public IP address assigned. Which gcloud command should the engineer use to provision this instance correctly?

  1. gcloud sql instances create app-db --database-version=MYSQL_8_0 --tier=db-n1-standard-2 --region=us-central1 --availability-type=REGIONAL --no-assign-ip --network=corp-vpcCevap
  2. B
    gcloud sql instances create app-db --database-version=MYSQL_8_0 --tier=db-n1-standard-2 --region=us-central1 --availability-type=REGIONAL --authorized-networks=0.0.0.0/0
  3. C
    gcloud sql instances create app-db --database-version=MYSQL_8_0 --tier=db-n1-standard-2 --region=us-central1 --ha-enabled --no-assign-ip --network=corp-vpc
  4. D
    gcloud sql instances create app-db --database-version=MYSQL_8_0 --tier=db-n1-standard-2 --region=us-central1 --availability-type=REGIONAL --preemptible --no-assign-ip --network=corp-vpc

Cevap

The command 'gcloud sql instances create app-db --database-version=MYSQL_8_0 --tier=db-n1-standard-2 --region=us-central1 --availability-type=REGIONAL --no-assign-ip --network=corp-vpc' correctly provisions a high-availability Cloud SQL instance on Private IP.
The correct command uses '--availability-type=REGIONAL' to configure high availability with cross-zone failover, along with '--no-assign-ip' and '--network=corp-vpc' to enforce private IP connectivity within the targeted VPC network.

Adım Adım Çözüm

1
Identify the high availability requirement for Cloud SQL.
Determine that --availability-type=REGIONAL must be specified in the gcloud CLI command.
Regional availability provisions a primary instance and a standby replica in a secondary zone within the same region for high availability.
2
Identify the networking and access requirements.
Combine --no-assign-ip and --network=corp-vpc.
The --no-assign-ip flag disables public IP assignment, while --network specifies the target VPC network for Private Service Access.
3
Construct and verify the complete gcloud command.
Combine instance creation flags into gcloud sql instances create app-db ...
Ensures all production constraints (regional HA, private IP connectivity, and accurate flag syntax) are satisfied.

Anahtar Kavram

Cloud SQL High Availability and Private IP Provisioning
Tahmini Süre:1m 30s
Bu soruyu puanla

Konular

Deploying and Configuring Managed Database Instances