Examkin

Question

Difficulty: EasyPlanning Database Options and Persistent Disk Types

A system administrator needs to deploy a fully managed relational database on Google Cloud to support an existing web application that uses a standard MySQL engine. Which Google Cloud database service best satisfies this requirement with minimal operational overhead?

  1. Cloud SQLAnswer
  2. B
    Cloud Bigtable
  3. C
    Firestore
  4. D
    Cloud Storage

Answer

Cloud SQL is the recommended service because it provides fully managed relational database instances running native MySQL.
Cloud SQL is Google Cloud's fully managed relational database service that directly supports standard MySQL, PostgreSQL, and SQL Server engines with automated backups, replication, and patching.

Step-by-Step Solution

1
Identify the data model and engine requirements
The workload requires a relational database model with standard MySQL engine compatibility.
Matching workload database requirements to Google Cloud offerings is key to selecting the proper managed service.
2
Evaluate Google Cloud database options against relational database support
Cloud SQL natively supports MySQL, PostgreSQL, and SQL Server as fully managed services.
NoSQL services like Firestore and Bigtable do not support standard SQL engines or relational schemas.

Key Concept

Selecting managed relational database services in GCP based on engine requirements
Estimated Time:45s
Rate this question

Topics

Planning Database Options and Persistent Disk Types

More questions from this topic