ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Associate Cloud Engineer All Questions

View all questions & answers for the Associate Cloud Engineer exam
Go to Exam

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 Hide Answer
Suggested Answer: B 🗳️
by ankitb4u at July 31, 2023, 2:37 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
VijKall
Highly Voted 10 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 13 times
...
kacper07
Most Recent 3 months ago
B is correct, even M$ copilot chose it :D
upvoted 1 times
...
ExamsFR
11 months, 2 weeks ago
Selected Answer: B
B is the correct answer.
upvoted 2 times
...
joao_01
11 months, 3 weeks ago
Selected Answer: B
Its B, makes sense
upvoted 2 times
...
Captain1212
12 months ago
B is the correrct answer as question demands global scalibity for it cloud spanner , for PostgreSQL to BIG query
upvoted 2 times
...
scanner2
12 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
...
3arle
1 year ago
Selected Answer: B
agree B
upvoted 1 times
...
Speridian
1 year, 1 month ago
B should be the answer. Cloud Spanner - Global support.
upvoted 1 times
...
[Removed]
1 year, 1 month ago
Selected Answer: B
B should be right
upvoted 3 times
...
ankitb4u
1 year, 1 month ago
B should be the answer as cloud spanner provides scalability
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago