Cloud Database Migration
Question
Your client, a global financial giant, plans to migrate its relational database currently running on-prem to the cloud.
Which of the below listed would be the most preferred option?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.Correct Answer: A.
Option A is Correct.
Fully-managed database service, Cloud SQL is a relational database service compatible with MySQL, PostgreSQL and SQL Server.
Option B is Incorrect.
Cloud Oracle is an Invalid service.
Option C is Incorrect.
Since BigTable is a NoSQL database service, it is not appropriate in this scenario.
Option D is Incorrect.
Please refer to the explanation above.
https://cloud.google.com/sql https://cloud.google.com/bigtableWhen it comes to migrating a relational database from on-premises to the cloud, there are several options available, including Cloud SQL, Cloud Oracle, and Cloud Bigtable. However, the most preferred option would depend on various factors such as the nature of the database, size of the data, type of application using the database, cost, and specific requirements of the client.
Cloud SQL is a fully-managed database service provided by Google Cloud Platform (GCP). It supports various open-source databases such as MySQL, PostgreSQL, and SQL Server. Cloud SQL provides automatic backups, automated patching, and high availability, making it a popular option for small to medium-sized databases. It also has a pay-as-you-go pricing model, making it cost-effective.
Cloud Oracle is a managed database service provided by Oracle on GCP. It is designed to run Oracle databases with high availability, automatic backups, and automated patching. Cloud Oracle provides all the benefits of Oracle database technology while eliminating the need for infrastructure management. However, it can be more expensive than Cloud SQL.
Cloud Bigtable is a NoSQL database service provided by Google Cloud Platform. It is designed to handle massive volumes of structured and semi-structured data with low latency and high performance. Cloud Bigtable is best suited for large-scale applications that require high throughput and low latency, such as real-time analytics and Internet of Things (IoT) devices.
Based on the above, the most preferred option for the global financial giant would be either Cloud SQL or Cloud Bigtable. If the relational database is small to medium-sized, with a predefined schema and transactional workload, Cloud SQL would be a good option due to its ease of use and cost-effectiveness. However, if the relational database is large and complex with a high volume of data, and the client needs high throughput and low latency, then Cloud Bigtable would be the best choice.
In conclusion, the answer would be D, either of A or C, depending on the specific requirements of the client.
