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 questionsThe 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.
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.
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".
Keep practicing
Take the free CLOUD-DATABASE-ENGINEER practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other CLOUD-DATABASE-ENGINEER practice questions
- Question 1Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After…
- Question 2Your company is developing a new global transactional application that must be ACID-compl…
- Question 3You are designing a database strategy for a new web application. You plan to start with a…
- Question 4Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on …
- Question 5You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises …
- Question 6You host an application in Google Cloud. The application is located in a single region an…
