MENU
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?
Suggested Answer: C
Get Premium Professional Cloud Database Engineer Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
27 comments · newest first
AS
Ashley
10 months ago
Totally agree with A, minimal disruption is key!
KA
Kallie
10 months ago
Wait, are we sure A is the right choice?
HE
Helaine
10 months ago
Definitely A! It keeps everything SQL Server.
JU
Jules
11 months ago
I think C could work too, but it might be more complex.
BE
Beth
11 months ago
A is the best option for SQL Server migration.
CA
Carrol
11 months ago
GKE sounds like it could be useful, but I feel like it's more suited for containerized applications, not for a direct SQL Server migration.
MO
Moon
11 months ago
I practiced a similar question, and I think Cloud SQL for PostgreSQL wouldn't be compatible with SQL Server features, so that seems wrong.
CH
Christiane
12 months ago
I'm not entirely sure, but I think migrating to Compute Engine could give us more control over the environment, right?
AU
Audra
12 months ago
I remember that Cloud SQL for SQL Server is designed specifically for SQL Server workloads, so it might be the best choice for minimal disruption.
GL
Glory
12 months ago
This is a tricky one. We need to consider not just the database, but the entire ecosystem of services we're using. I'm not sure if Cloud SQL for SQL Server would fully accommodate SSAS, SSRS, and SSIS. Option D, Migrate to GKE, might give us more flexibility to lift and shift the whole environment.
LE
Leana
1 year ago
I think the key here is to minimize disruption to the existing architecture. That makes me lean towards option A - Migrate to Cloud SQL for SQL Server. It should provide a relatively seamless transition since it's the closest match to our current setup.
AL
Alease
1 year ago
Hmm, I'm a bit confused here. We're using a lot of Microsoft SQL Server components like SSAS, SSRS, and SSIS. I'm not sure if migrating to Cloud SQL for SQL Server would fully support all of those services. Maybe option D, Migrate to GKE, could be a better fit to maintain the full Microsoft stack.
SA
Salina
1 year ago
This seems like a straightforward migration question. I'd go with option A - Migrate to Cloud SQL for SQL Server since that would allow us to keep the existing SQL Server architecture and minimize disruption.
AH
Ahmed
1 year ago
But what about migrating to Compute Engine? Wouldn't that be a better option?
LU
Luis
1 year ago
I'm not sure about D. Kubernetes seems like overkill for a simple database migration. Unless you really need the advanced container orchestration features.
BE
Beckie
9 months ago
Compute Engine could work too, but it might need more management.
AL
Alesia
10 months ago
Definitely! Cloud SQL for SQL Server seems more straightforward.
MI
Mira
10 months ago
I agree, Kubernetes feels too complex for this.
YO
Yoko
11 months ago
Yeah, I think A is the best option for minimal disruption.
BE
Ben
1 year ago
I agree with Candida, it will ensure minimal disruption to the existing architecture.
GL
Gladys
1 year ago
Hmm, I don't know. Wouldn't Compute Engine give us more flexibility to customize the infrastructure? Although the migration might be a bit more complex.
EL
Eleni
1 year ago
A) Migrate to Cloud SQL for SQL Server.
CA
Candida
1 year ago
I think we should migrate to Cloud SQL for SQL Server.
RO
Rolf
1 year ago
A is the way to go. Cloud SQL for SQL Server is the most straightforward option, and it keeps the same database engine we're already using.
WA
Wade
1 year ago
Agreed. It's important to minimize any potential issues during the migration.
DE
Delila
1 year ago
That makes sense. It will be the least disruptive option.
JU
Julie
1 year ago
A) Migrate to Cloud SQL for SQL Server.