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?
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.
B: Cloud SQL is Google Cloud's fully managed database service that supports SQL Server, among other databases like MySQL and PostgreSQL. By migrating to Cloud SQL, the organization can leverage a managed service that handles much of the database administration tasks such as patching, updates, and setup, thereby reducing management overhead.
Cloud SQL also offers automatic scaling capabilities, addressing the concern about capacity that the organization is facing with their on-premise solution.
Migrating to Cloud SQL would involve minimal changes to the existing applications since it supports SQL Server, allowing for a smoother transition without needing extensive application refactoring or redevelopment.
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
bumbleoats
3 months, 2 weeks agoVivek007
7 months ago