Google Cloud Professional Cloud Database Engineer — Question 88

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?

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: D

Explanation

The correct answer is D because Cloud SQL provides a fully managed service for MySQL, SQL Server, and PostgreSQL, which fits the requirement for a flexible database solution. Option A fails to address the Oracle databases, while Option B incorrectly places PostgreSQL on Compute Engine. Option C also incorrectly places MySQL and SQL Server on Compute Engine, which does not provide the same level of management as Cloud SQL.