Exam Associate Cloud Engineer topic 1 question 219 discussion

Actual exam question from Google's Associate Cloud Engineer

Question #: 219
Topic #: 1

[All Associate Cloud Engineer Questions]

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?

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.

Show Suggested Answer

Suggested Answer: B 🗳️

by ankitb4u at July 31, 2023, 2:37 p.m.

Comments

Submit Cancel

VijKall

Highly Voted 1 year, 3 months ago

Selected Answer: B

Needs Global scalability ---- Spanner is in, CloudSQL is out. Kafka --> Pub/Sub & not memory store. Postgres --> BigQuery as it needs scalability and for analytics.

upvoted 14 times

...

kacper07

Most Recent 8 months ago

B is correct, even M$ copilot chose it :D

upvoted 1 times

...

ExamsFR

1 year, 4 months ago

Selected Answer: B

B is the correct answer.

upvoted 2 times

...

joao_01

1 year, 4 months ago

Selected Answer: B

Its B, makes sense

upvoted 2 times

...

Captain1212

1 year, 4 months ago

B is the correrct answer as question demands global scalibity for it cloud spanner , for PostgreSQL to BIG query

upvoted 3 times

...

scanner2

1 year, 4 months ago

Selected Answer: B

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

upvoted 2 times

...