Google Cloud Digital Leader — Question 117

An organization is running SQL Server on-premises and is struggling with capacity and management overhead. They want to modernize this database quickly by using Google products or services. What should the organization do?

Answer options

• A. Refactor applications to use a cloud first database like Firestore.
• B. Perform a managed database migration to Cloud SQL.
• C. Export old tables from SQL Server to Cloud Storage.
• D. Migrate all SQL Server data to BigQuery.

Correct answer: B

Explanation

The correct answer is B because performing a managed database migration to Cloud SQL allows for a seamless transition with reduced management overhead. Options A and D suggest alternatives that may not address the specific needs for a quick modernization, while option C does not provide a complete migration solution.