A system engineer needs to provision a production Cloud SQL for MySQL instance named 'prod-mysql-db' in the us-central1 region. Organizational security policies mandate that the database instance must connect exclusively via Private IP within the custom Virtual Private Cloud (VPC) network named 'prod-vpc' and must not have an external public IP address assigned. Which gcloud command correctly provisions the Cloud SQL instance to meet these security requirements?
- gcloud sql instances create prod-mysql-db --database-version=MYSQL_8_0 --cpu=4 --memory=16GiB --network=projects/my-project/global/networks/prod-vpc --no-assign-ip --region=us-central1Cevap
- Bgcloud sql instances create prod-mysql-db --database-version=MYSQL_8_0 --cpu=4 --memory=16GiB --authorized-networks=prod-vpc --region=us-central1
- Cgcloud sql instances create prod-mysql-db --database-version=MYSQL_8_0 --cpu=4 --memory=16GiB --enable-private-ip --vpc-name=prod-vpc --region=us-central1
- Dgcloud sql instances create prod-mysql-db --database-version=MYSQL_8_0 --cpu=4 --memory=16GiB --network=prod-vpc --assign-ip --region=us-central1
Cevap
The command specifying '--network=projects/my-project/global/networks/prod-vpc' alongside '--no-assign-ip' correctly provisions the Cloud SQL instance with Private IP connectivity while suppressing public IP address assignment.
Provisioning a Cloud SQL instance with exclusive Private IP access requires attaching it to the target VPC network using the `--network` parameter and disabling public IP address allocation using `--no-assign-ip`.
Adım Adım Çözüm
Anahtar Kavram
Cloud SQL Private IP Instance Provisioning
Tahmini Süre:1m 30s