Question

Difficulty: MediumDeploying and Configuring Managed Database Instances

A solutions architect is automating the deployment of a managed NoSQL database service on Google Cloud to handle low-latency, high-throughput time-series writes from millions of IoT telemetry sensors. The application requires consistent sub-10ms performance and high availability. The database instance named `telemetry-db` must be deployed using the Google Cloud CLI with an initial cluster named `telemetry-c1` in the `us-central1-a` zone with 3 nodes. Which `gcloud` command correctly provisions this instance?

  1. gcloud bigtable instances create telemetry-db --display-name="Telemetry DB" --cluster=telemetry-c1 --cluster-zone=us-central1-a --cluster-num-nodes=3 --cluster-storage-type=SSDAnswer
  2. B
    gcloud bigtable instances create telemetry-db --display-name="Telemetry DB" --cluster=telemetry-c1 --cluster-zone=us-central1-a --cluster-num-nodes=3 --cluster-storage-type=HDD
  3. C
    gcloud sql instances create telemetry-db --database-version=POSTGRES_15 --tier=db-custom-4-16384 --zone=us-central1-a --storage-type=SSD
  4. D
    gcloud bigtable instances create telemetry-db --display-name="Telemetry DB" --instance-type=DEVELOPMENT --cluster=telemetry-c1 --cluster-zone=us-central1-a --cluster-storage-type=SSD

Answer

The command 'gcloud bigtable instances create telemetry-db --display-name="Telemetry DB" --cluster=telemetry-c1 --cluster-zone=us-central1-a --cluster-num-nodes=3 --cluster-storage-type=SSD' correctly provisions a Cloud Bigtable instance with SSD storage for low-latency IoT time-series data.
The correct command uses `gcloud bigtable instances create` with `--cluster-storage-type=SSD` and 3 cluster nodes in the specified zone. Cloud Bigtable is the optimal GCP managed database service for massive NoSQL time-series ingestion, and SSD storage ensures low-latency performance required by the SLA.

Step-by-Step Solution

1
Identify database engine requirements
Cloud Bigtable is selected because the workload demands low-latency, high-throughput NoSQL time-series data ingestion.
Matching workload requirements to the appropriate managed GCP database product.
2
Determine appropriate storage disk type
SSD storage (--cluster-storage-type=SSD) is required to guarantee sub-10ms read/write performance.
HDD storage does not meet low-latency performance SLAs.
3
Formulate the correct gcloud CLI syntax
Use `gcloud bigtable instances create` specifying instance name, cluster name, zone, node count, and SSD storage.
Ensures proper automated provisioning using Google Cloud CLI flags.

Key Concept

Provisioning Cloud Bigtable Instances with gcloud CLI
Rate this question