GCP - Cloud SQL and Databases
You want to migrate an on-premises SQL Server 2019 database to Cloud SQL. Which Cloud SQL engine and version should you select to ensure maximum compatibility?
You want to migrate an on-premises SQL Server 2019 database to Cloud SQL. Which Cloud SQL engine and version should you select to ensure maximum compatibility?
hard📝 Best Practice Q8 of 15
Step-by-Step Solution
Solution:
Step 1: Identify Cloud SQL engine matching on-premises version
Cloud SQL supports SQL Server 2019, which matches the on-premises version.Step 2: Choose engine for maximum compatibility
Selecting SQL Server 2019 ensures feature and compatibility alignment for migration.Final Answer:
SQL Server 2019 -> Option BQuick Check:
Matching SQL Server version = A [OK]
Quick Trick: Match Cloud SQL engine version to on-premises for smooth migration [OK]
Common Mistakes:
- Choosing older SQL Server versions
- Selecting different database engines
Master "Cloud SQL and Databases" in GCP
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore GCP Quizzes