This question is part of a case study — click to read the full scenario(Case 06)
CASE STUDY: RetailMart
Overview: Global e-commerce, 5,000 employees. Legacy monolith on VMware, 20TB Oracle DB on-prem.
Business: Modernize to microservices, 100% uptime during Black Friday (10x traffic), real-time inventory sync, exit data center in 2 years.
Executives:
- CEO: "Innovate faster to beat online-only competitors."
- CFO: "End hardware CAPEX. Move to pure OPEX."
- CTO: "Break monolith safely. Zero downtime during transition."
Tech: Migrate off Oracle to open-source, containerize, secure hybrid connectivity during transition, automated scaling.
Constraints: Zero downtime for storefront, heavy reliance on Oracle stored procedures, all hybrid traffic must be private/encrypted.
Which migration approach should you recommend to safely break down the monolith with zero downtime?
GCP PCA · Question 08 · Domain 1: Designing and Planning a Cloud Solution Architecture
CASE STUDY: RetailMart
Overview: Global e-commerce, 5,000 employees. Legacy monolith on VMware, 20TB Oracle DB on-prem.
Business: Modernize to microservices, 100% uptime during Black Friday (10x traffic), real-time inventory sync, exit data center in 2 years.
Executives:
- CEO: "Innovate faster to beat online-only competitors."
- CFO: "End hardware CAPEX. Move to pure OPEX."
- CTO: "Break monolith safely. Zero downtime during transition."
Tech: Migrate off Oracle to open-source, containerize, secure hybrid connectivity during transition, automated scaling.
Constraints: Zero downtime for storefront, heavy reliance on Oracle stored procedures, all hybrid traffic must be private/encrypted.
Which strategy should you use to migrate the 20TB Oracle database to an open-source solution with zero downtime?
CASE STUDY: RetailMart
Overview: Global e-commerce, 5,000 employees. Legacy monolith on VMware, 20TB Oracle DB on-prem.
Business: Modernize to microservices, 100% uptime during Black Friday (10x traffic), real-time inventory sync, exit data center in 2 years.
Executives:
- CEO: "Innovate faster to beat online-only competitors."
- CFO: "End hardware CAPEX. Move to pure OPEX."
- CTO: "Break monolith safely. Zero downtime during transition."
Tech: Migrate off Oracle to open-source, containerize, secure hybrid connectivity during transition, automated scaling.
Constraints: Zero downtime for storefront, heavy reliance on Oracle stored procedures, all hybrid traffic must be private/encrypted.
Which strategy should you use to migrate the 20TB Oracle database to an open-source solution with zero downtime?
Answer options:
Export the Oracle database to CSV files, upload to Cloud Storage, and import into Cloud Spanner.
Use Datastream to replicate data continuously from Oracle to Cloud SQL for PostgreSQL, and rewrite the stored procedures in the application layer.
Migrate to Bare Metal Solution for Oracle to maintain the stored procedures.
Use Database Migration Service (DMS) to migrate directly to BigQuery.
How to approach this question
Full Answer
Common mistakes
Practice the full GCP Professional Cloud Architect Practice Exam 4
50 questions · hints · full answers · grading
Expert