nerdexam
Google

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…

Planning and Designing a Database Solution

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)
  • A
    10% (4)
  • B
    15% (6)
  • C
    5% (2)
  • D
    70% (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

#Database Migration#Cloud SQL#Oracle Migration#Managed Databases

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice