CLOUD-DATABASE-ENGINEER practice question 16 of 25

Your company wants you to migrate their Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud. You need a fully managed, flexible database solution when possible. What should you do?

Full set: 141 questions
Answer options
A: Migrate all the databases to Cloud SQL.
B: Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.
C: Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.
D: Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle. Correct answer
Correct Answer:
D. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.
Explanation

The requirement is for a fully managed and flexible database solution where possible. Cloud SQL is Google Cloud's fully managed relational database service, which supports MySQL, PostgreSQL, and SQL Server. This makes it the ideal choice for these three databases. However, Cloud SQL does not support Oracle. The recommended and certified solution for migrating specialized Oracle workloads to Google Cloud is the Bare Metal Solution for Oracle. This approach correctly applies the most appropriate managed or specialized service for each database type mentioned in the scenario.

Why Incorrect

A. This is incorrect because Cloud SQL does not provide a managed service for Oracle databases.
B. This is incorrect because Cloud SQL does not support Oracle, and it is the preferred fully managed solution for PostgreSQL over a self-managed Compute Engine instance.
C. This is incorrect because using Compute Engine for MySQL, SQL Server, and PostgreSQL is not a fully managed solution, which violates the primary requirement.

References

1. Google Cloud Documentation, "Cloud SQL documentation": In the introduction, it states, "Cloud SQL is a fully managed relational database service for MySQL, PostgreSQL, and SQL Server." This confirms that Cloud SQL is the correct fully managed choice for these three databases.

Source: Google Cloud, "Introduction to Cloud SQL", https://cloud.google.com/sql/docs/introduction, Paragraph 1.

2. Google Cloud Documentation, "Bare Metal Solution documentation": The overview explains, "Bare Metal Solution provides you with hardware to run specialized workloads with low latency on Google Cloud... You can run your Oracle database on Bare Metal Solution servers...". This identifies Bare Metal Solution as the appropriate platform for Oracle workloads.

Source: Google Cloud, "Bare Metal Solution overview", https://cloud.google.com/bare-metal/docs/bms-overview, Section: "Run your specialized workloads on Bare Metal Solution".

3. Google Cloud Solutions, "Database Migration: Get Started": This guide outlines migration paths. For MySQL, PostgreSQL, and SQL Server, it lists "Migrate to Cloud SQL" as a primary option. For Oracle, it lists "Bare Metal Solution" as a key strategy for bringing Oracle workloads to Google Cloud.

Source: Google Cloud, "Database Migration: Get Started", https://cloud.google.com/solutions/database-migration/get-started, Section: "Choose your migration path".

Scroll to Top