Examkin

Question

Difficulty: EasyManaging Technology Debt and Legacy Cloud Migrations

An enterprise plans to migrate an on-premises legacy relational database to Google Cloud. The workload consists of standard single-region transactional processing and does not require global scale or multi-region synchronous replication. To minimize ongoing technical debt, operational complexity, and unnecessary costs, which Google Cloud service should the cloud architect recommend?

  1. Cloud SQLAnswer
  2. B
    Cloud Spanner
  3. C
    Transfer Appliance
  4. D
    Google Kubernetes Engine (GKE)

Answer

Cloud SQL is the recommended solution because it fulfills standard relational database requirements in a fully managed service, avoiding the cost and complexity of over-engineered database platforms.
Cloud SQL provides a fully managed relational database service (supporting MySQL, PostgreSQL, and SQL Server) optimized for standard regional applications. Implementing Cloud SQL meets all legacy data migration requirements while minimizing operational maintenance and cloud overhead.

Step-by-Step Solution

1
Analyze the technical requirements of the legacy application
The application requires a standard relational database operating within a single region without needing global multi-region consistency.
Matching technical requirements to the appropriate managed service tier prevents over-provisioning.
2
Evaluate target GCP database services against operational constraints
Cloud SQL handles standard regional transactional workloads natively with minimal operational overhead.
Choosing fully managed services suited to the workload scale reduces long-term technology debt.

Key Concept

Selecting right-sized managed database services during legacy migration to minimize technical debt
Rate this question

Topics

Managing Technology Debt and Legacy Cloud Migrations

More questions from this topic