Google Cloud Associate Cloud Engineer — Question 202

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?

Answer options

• A. Migrate from MySQL to Cloud SQL, from Kafka to Pub/Sub, and from Cloud SQL for PostgreSQL to BigQuery.
• B. Migrate from MySQL to Cloud Spanner, from Kafka to Pub/Sub, and from Cloud SQL for PostgreSQL to BigQuery.
• C. Migrate from MySQL to Cloud Spanner, from Kafka to Memorystore, and from Cloud SQL for PostgreSQL to Cloud SQL.
• D. Migrate from MySQL to Cloud SQL, from Kafka to Memorystore, and from Cloud SQL for PostgreSQL to Cloud SQL.

Correct answer: B

Explanation

The correct answer is B because Cloud Spanner provides horizontal scalability and strong consistency, making it suitable for migrating MySQL. Pub/Sub is designed for event-driven architectures, making it an ideal replacement for Kafka, while BigQuery is optimized for analytics, making it the best choice for your PostgreSQL needs. The other options either do not utilize the recommended services for scalability or do not align with the goals of minimal operational management.