Question 131 · 325 in bank
You are planning to migrate the following on-premises data management solutions to Google Cloud: • One MySQL cluster for your main database • Apache Kafka for your event streaming platform • One Cloud SQL for PostgreSQL database for your analytical and reporting needs You want to implement Google-recommended solutions for the migration. You need to ensure that the new solutions provide global scalability and require minimal operational and infrastructure management. What should you do?
Show answer
Answer: B
Explanation
For event streaming -> Cloud Pub/Sub is a good choice. https://cloud.google.com/pubsub/docs/overview Database for analytics and reporting -> BigQuery is a good choice. https://cloud.google.com/bigquery/docs/introduction For MySQL, we have two options Cloud SQL or Cloud Spanner. Cloud SQL has MySQL flavored database, while Cloud Spanner provide Google Standard SQL (aka GoogleSQL) which supports standard SQL queries. In addition, the question is asking about "global scalability and require minimal operational and infrastructure management", where Cloud Spanner wins a score. Hence, B is the correct answer. https://cloud.google.com/spanner https://cloud.google.com/spanner/docs/create-query-database-console#create-instance https://cloud.google.com/spanner/docs/create-query-database-console#create-database
Source: Adapted from community discussion — scanner2