Google Cloud Professional Cloud Database Engineer — Question 38

Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?

Answer options

• A. Migrate to Cloud SQL for SQL Server.
• B. Migrate to Cloud SQL for PostgreSQL.
• C. Migrate to Compute Engine.
• D. Migrate to Google Kubernetes Engine (GKE).

Correct answer: C

Explanation

The correct choice is C, as migrating to Compute Engine allows for the most flexibility and control over the SQL Server environment, enabling a smooth transition without significant changes to the existing architecture. Options A and B involve using managed services that may not support the same features as SQL Server, while D suggests a container orchestration platform that is less suited for direct database migration.