Examkin

Question

Difficulty: MediumDeploying and Configuring Managed Database Instances

An enterprise application requires a managed relational database service that provides horizontal scaling across multiple Google Cloud regions while maintaining transactional consistency for both read and write operations. A cloud engineer must provision this database using the Google Cloud CLI. Which command correctly provisions the appropriate managed database instance to meet these requirements?

  1. gcloud spanner instances create prod-db --config=nam-eur-asia1 --description="Production Database" --nodes=3Answer
  2. B
    gcloud sql instances create prod-db --tier=db-custom-4-16384 --region=us-central1 --multi-region-failover
  3. C
    gcloud bigtable instances create prod-db --cluster=prod-c1 --cluster-zone=us-central1-a --instance-type=RELATIONAL
  4. D
    gcloud datastore instances create prod-db --region=nam5 --transactional-sql

Answer

Execute gcloud spanner instances create with a multi-region configuration (--config) to provision a horizontally scalable, multi-region relational database.
The requirement specifies a managed relational database that provides multi-region horizontal scaling and strong transactional consistency for both reads and writes. Cloud Spanner is the only Google Cloud database designed for this exact combination of requirements. The gcloud spanner instances create command using a multi-region instance configuration (such as nam-eur-asia1) is the standard CLI method to deploy a Cloud Spanner instance.

Step-by-Step Solution

1
Analyze the workload requirements
Identified requirements for a relational database with multi-region horizontal scaling and transactional consistency (ACID).
Cloud SQL provides relational capabilities within a single region (or with read-only replicas), but only Cloud Spanner satisfies multi-region transactional consistency with horizontal write scaling.
2
Select the appropriate GCP managed database service
Selected Cloud Spanner as the target database engine.
Cloud Spanner is built specifically for global relational transactions and high availability.
3
Formulate the correct gcloud CLI provisioning command
Used gcloud spanner instances create with required flags (--config, --description, --nodes).
This command directly creates the managed Cloud Spanner instance according to Google Cloud CLI standards.

Key Concept

Selecting and Provisioning Managed Databases (Cloud Spanner vs. Cloud SQL vs. Bigtable)
Estimated Time:1m 15s
Rate this question

Topics

Deploying and Configuring Managed Database Instances