PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #53
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…
The correct answer is D. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and. Cloud SQL supports MySQL, PostgreSQL, and Microsoft SQL Server as fully managed offerings. Oracle, however, is not supported by Cloud SQL. The correct answer (D) migrates MySQL, Microsoft SQL Server, and PostgreSQL to Cloud SQL (the fully managed option), and migrates the…
Question
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?
Options
- AMigrate all the databases to Cloud SQL.
- BMigrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the
- CMigrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and
- DMigrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and
How the community answered
(40 responses)- A10% (4)
- B15% (6)
- C5% (2)
- D70% (28)
Explanation
Cloud SQL supports MySQL, PostgreSQL, and Microsoft SQL Server as fully managed offerings. Oracle, however, is not supported by Cloud SQL. The correct answer (D) migrates MySQL, Microsoft SQL Server, and PostgreSQL to Cloud SQL (the fully managed option), and migrates the Oracle databases to Bare Metal Solution for Oracle - which is Google's dedicated infrastructure solution for running Oracle workloads in Google Cloud while maintaining Oracle license compliance and using native Oracle tooling. Options A and B are incorrect because Cloud SQL does not support Oracle. Option C is incorrect because it puts databases on Compute Engine (IaaS, not fully managed) rather than Cloud SQL.
Topics
Community Discussion
No community discussion yet for this question.