Examkin

Question

Difficulty: EasyDeploying and Configuring Managed Database Instances

An administrator is deploying a new Cloud SQL database instance using the Google Cloud CLI. Which parameter must be specified in the gcloud command to set the database engine version to MySQL 8.0?

  1. --database-version=MYSQL_8_0Answer
  2. B
    --authorized-networks=0.0.0.0/0
  3. C
    --engine-type=MYSQL_8_0
  4. D
    --db-kind=relational

Answer

The correct parameter to specify the database engine version during Cloud SQL deployment is `--database-version=MYSQL_8_0`.
When executing `gcloud sql instances create`, the `--database-version` flag specifies the database engine type and major version (such as `MYSQL_8_0`, `POSTGRES_15`, etc.).

Step-by-Step Solution

1
Identify the requirement for provisioning a Cloud SQL instance with a specific database engine version.
Recognize that the gcloud CLI tool uses explicit flags to configure instance parameters.
When executing `gcloud sql instances create INSTANCE_NAME`, configuration settings such as database engine, tier, and region are controlled via specific command flags.
2
Evaluate the flags provided in the choices against official gcloud CLI syntax.
Determine that `--database-version` is the valid flag for setting engine versions such as `MYSQL_8_0`, `POSTGRES_14`, or `SQLSERVER_2019_STANDARD`.
Other flags like `--engine-type` or `--db-kind` do not exist in the Google Cloud SDK for Cloud SQL instance creation.

Key Concept

Configuring Cloud SQL Engine Versions via gcloud CLI
Estimated Time:45s
Rate this question

Topics

Deploying and Configuring Managed Database Instances