• Home
  • Recent Q&A
  • Java
  • Cloud
  • JavaScript
  • Python
  • SQL
  • PHP
  • HTML
  • C++
  • Data Science
  • DBMS
  • Devops
  • Hadoop
  • Machine Learning
in Cloud Computing by
Q:

You are responsible for planning the migration to GCP of an important application that works with Oracle Database.
A horizontally scalable and globally functioning SQL database is required.
Which service is better to use and which type of schema migration is recommended?

A. Cloud SQL with no schema migration
B. Cloud SQL with sequential primary keys migration
C. Cloud Spanner with no schema migration
D. Cloud Spanner with sequential primary keys migration

1 Answer

0 votes
by

Correct Answer: D
The requirements point to an SQL Database that is global and distributed with synchronized replicas and shards in multiple Servers: Cloud Spanner.
The risk of hotspotting with synchronized replicas needs to be addressed; that is updates that are not distributed among multiple servers.

Related questions

0 votes
asked Dec 2, 2021 in Cloud Computing by DavidAnderson
0 votes
asked Dec 1, 2021 in Cloud Computing by DavidAnderson
...