Question

Difficulty: HardDeploying and Configuring Managed Database Instances

A database engineer is deploying a Cloud Spanner instance named `prod-spanner-db` to support a high-throughput transactional service. The workload requires sub-node scaling, specifically 300 processing units of compute capacity, hosted in the `us-east1` region. Which `gcloud` command correctly provisions this Cloud Spanner instance according to Google Cloud best practices?

  1. gcloud spanner instances create prod-spanner-db --config=regional-us-east1 --description="Production DB" --processing-units=300Answer
  2. B
    gcloud spanner instances create prod-spanner-db --config=regional-us-east1 --description="Production DB" --nodes=0.3
  3. C
    gcloud spanner instances create prod-spanner-db --config=regional-us-east1 --description="Production DB" --nodes=300
  4. D
    gcloud sql instances create prod-spanner-db --tier=db-custom-2-3750 --region=us-east1 --database-version=SPANNER

Answer

The command `gcloud spanner instances create prod-spanner-db --config=regional-us-east1 --description="Production DB" --processing-units=300` correctly provisions the instance.
The correct option executes `gcloud spanner instances create` specifying `--processing-units=300`. In Google Cloud Spanner, compute capacity below 1 full node (1,000 processing units) is configured using the `--processing-units` flag in increments of 100.

Step-by-Step Solution

1
Identify the target managed database product and command group
Cloud Spanner deployment requires the `gcloud spanner instances create` command group.
Cloud SQL CLI commands (`gcloud sql`) cannot provision or manage Cloud Spanner instances.
2
Determine compute capacity units for sub-node scaling
Specify compute capacity using `--processing-units=300`.
Cloud Spanner compute capacity is defined in processing units (where 1,000 processing units equal 1 node). Compute capacity under 1 node must be specified using `--processing-units` with integer multiples of 100, as `--nodes` does not accept fractional values.
3
Verify region and instance parameters
Pass `--config=regional-us-east1` to specify regional deployment in `us-east1`.
Spanner instance configurations use regional or multi-regional config strings to define geographical placement.

Key Concept

Cloud Spanner Instance Provisioning and Processing Unit Scaling via gcloud CLI
Estimated Time:2m 0s
Rate this question