Examkin

Question

Difficulty: EasyProvisioning Storage and Database Systems

An infrastructure engineer needs to provision a managed relational database on Google Cloud for a standard regional web application that requires ACID compliance and automatic high-availability failover. The application does not require global multi-region scaling. Which Google Cloud database service should be provisioned?

  1. Cloud SQLAnswer
  2. B
    Cloud Spanner
  3. C
    Storage Transfer Service
  4. D
    Cloud Storage configured with Customer-Supplied Encryption Keys (CSEK)

Answer

Cloud SQL is the correct database service to provision for a standard regional relational workload requiring high availability.
Cloud SQL is Google Cloud's fully managed relational database service supporting PostgreSQL, MySQL, and SQL Server engines. It supports regional high-availability configurations out of the box, making it the standard choice for regional transactional relational workloads.

Step-by-Step Solution

1
Identify workload characteristics
Workload requires relational database properties (ACID compliance), regional scope, and managed high availability.
Matching technical requirements to the appropriate managed GCP storage and database service.
2
Evaluate GCP database options
Cloud SQL provides managed PostgreSQL, MySQL, and SQL Server database instances with regional high-availability options.
Cloud SQL fits standard regional database workloads cost-effectively without global overhead.

Key Concept

Provisioning Cloud SQL for regional relational workloads
Estimated Time:45s
Rate this question

Topics

Provisioning Storage and Database Systems

More questions from this topic